APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_AM_ASSET_DETAILS_UV

Line 188: OKL_AM_ASSET_DETAILS_UV AD,

184: AD.SERIAL_NUMBER SERIAL_NUMBER, AD.MODEL_NUMBER MODEL_NUMBER,
185: OAR.DATE_REPOSSESSION_ACTUAL DATE_RETURNED, AD.ID KLE_ID,
186: OAR.COMMENTS COMMENTS
187: FROM
188: OKL_AM_ASSET_DETAILS_UV AD,
189: OKL_ASSET_RETURNS_V OAR
190: WHERE
191: AD.ID = OAR.KLE_ID
192: AND oar.id = c_art_id; */

Line 574: FROM OKL_AM_ASSET_DETAILS_UV AD

570: AD.ITEM_DESCRIPTION ASSET_DESCRIPTION,
571: AD.CONTRACT_NUMBER CONTRACT_NUMBER, AD.NAME ASSET_NUMBER,
572: AD.SERIAL_NUMBER SERIAL_NUMBER, AD.MODEL_NUMBER MODEL_NUMBER,
573: AD.ID KLE_ID
574: FROM OKL_AM_ASSET_DETAILS_UV AD
575: WHERE AD.ID = c_kle_id;
576: l_asset_detail okl_asset_details_csr%rowtype;
577: --end cdubey for bug 5253787
578:

Line 1915: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR

1911: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
1912: AD.SERIAL_NUMBER SERIAL_NUMBER,
1913: AD.MODEL_NUMBER MODEL_NUMBER,
1914: OAR.COMMENTS COMMENTS
1915: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR
1916: WHERE AD.ID = OAR.KLE_ID
1917: AND OAR.ID = c_art_id;
1918: */
1919: SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 1928: FROM OKL_AM_ASSET_DETAILS_UV AD,

1924: AD.MODEL_NUMBER MODEL_NUMBER,
1925: OAR.COMMENTS COMMENTS,
1926: C.CONTACT_PARTY_NAME CONTACT_NAME,
1927: CP.CONTACT_DETAILS CONTACT_DETAILS
1928: FROM OKL_AM_ASSET_DETAILS_UV AD,
1929: OKL_ASSET_RETURNS_V OAR,
1930: OKL_RELOCATE_ASSETS_V ORA,
1931: OKL_AM_CONTACT_POINTS_UV CP,
1932: OKL_AM_CONTACTS_UV C