OKL Lease Shipping Instructions

  SELECT    AR.KLE_ID                           KLE_ID,
            AR.DATE_RETURN_DUE                  DATE_RETURN_DUE,
            CP.CONTACT_PARTY_ID                 PAC_ID, 
            CONTACT_PARTY_NAME                  CONTACT_PARTY_NAME,
            CDL.NAME                            ASSET_NUMBER,
            CDL.ITEM_DESCRIPTION               ASSET_DESCRIPTION, 
            CHR.CUST_ACCT_ID                    CUST_ACCOUNT_ID,
            CHR.AUTHORING_ORG_ID                ORG_ID,
            CHR.CONTRACT_NUMBER                CONTRACT_NUMBER,
            OALV.SERIAL_NUMBER SERIAL_NUMBER, 
            OALV.MODEL_NUMBER MODEL_NUMBER,
            OALV.ORIGINAL_COST ASSET_COST
    FROM    OKL_ASSET_RETURNS_B       AR,
            OKL_RELOCATE_ASSETS_B     RA,
            OKL_AM_CONTACT_POINTS_UV  CP,
            OKL_AM_CONTACTS_UV        C,
            OKL_K_LINES_FULL_V CDL ,
            OKC_LINE_STYLES_B LSTY,
            OKC_K_HEADERS_B CHR,
            OKX_ASSET_LINES_V OALV
    WHERE    AR.ID               = :P_ART_ID
    AND      AR.ID               = RA.ART_ID
    AND      PAC_ID              = CP.CONTACT_CONTACT_POINT_ID
    AND      CP.CONTACT_PARTY_ID = C.CONTACT_PARTY_ID
    AND      CDL.LSE_ID          = LSTY.ID 
    AND      LSTY.LTY_CODE       ='FREE_FORM1'
    AND    CDL.DNZ_CHR_ID = CHR.ID
    AND      AR.KLE_ID           = CDL.ID
    AND      CDL.ID = OALV.PARENT_LINE_ID