OKL Lease Shipping Instructions
Description
Categories: BI Publisher
Application: Lease and Finance Management
Source:
Short Name: OKLSHIPINSTR
DB package:
Source:
Short Name: OKLSHIPINSTR
DB package:
Run
OKL Lease Shipping Instructions and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |