DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_AM_CONTACT_POINTS_UV

Line 1325: ,okl_am_contact_points_uv cp

1321: IS
1322: SELECT ra.last_updated_by, cp.contact_party_id pac_id, contact_party_name
1323: FROM okl_asset_returns_b ar
1324: ,okl_relocate_assets_b ra
1325: ,okl_am_contact_points_uv cp
1326: ,okl_am_contacts_uv c
1327: WHERE ar.id = c_art_id
1328: AND ar.id = ra.art_id
1329: AND pac_id = cp.contact_contact_point_id

Line 1931: OKL_AM_CONTACT_POINTS_UV CP,

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
1933: WHERE AD.ID = OAR.KLE_ID
1934: AND OAR.ID = c_art_id
1935: AND OAR.ID = ORA.ART_ID