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 1972: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR

1968: AD.CONTRACT_NUMBER CONTRACT_NUMBER,
1969: AD.SERIAL_NUMBER SERIAL_NUMBER,
1970: AD.MODEL_NUMBER MODEL_NUMBER,
1971: OAR.COMMENTS COMMENTS
1972: FROM OKL_AM_ASSET_DETAILS_UV AD, OKL_ASSET_RETURNS_V OAR
1973: WHERE AD.ID = OAR.KLE_ID
1974: AND OAR.ID = c_art_id;
1975: */
1976: SELECT OAR.LAST_UPDATED_BY LAST_UPDATED_BY,

Line 1985: FROM OKL_AM_ASSET_DETAILS_UV AD,

1981: AD.MODEL_NUMBER MODEL_NUMBER,
1982: OAR.COMMENTS COMMENTS,
1983: C.CONTACT_PARTY_NAME CONTACT_NAME,
1984: CP.CONTACT_DETAILS CONTACT_DETAILS
1985: FROM OKL_AM_ASSET_DETAILS_UV AD,
1986: OKL_ASSET_RETURNS_V OAR,
1987: OKL_RELOCATE_ASSETS_V ORA,
1988: OKL_AM_CONTACT_POINTS_UV CP,
1989: OKL_AM_CONTACTS_UV C