DBA Data[Home] [Help]

APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_AM_CONTACT_POINTS_UV

Line 1370: ,okl_am_contact_points_uv cp

1366: IS
1367: SELECT ra.last_updated_by, cp.contact_party_id pac_id, contact_party_name
1368: FROM okl_asset_returns_b ar
1369: ,okl_relocate_assets_b ra
1370: ,okl_am_contact_points_uv cp
1371: ,okl_am_contacts_uv c
1372: WHERE ar.id = c_art_id
1373: AND ar.id = ra.art_id
1374: AND pac_id = cp.contact_contact_point_id

Line 1988: OKL_AM_CONTACT_POINTS_UV CP,

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
1990: WHERE AD.ID = OAR.KLE_ID
1991: AND OAR.ID = c_art_id
1992: AND OAR.ID = ORA.ART_ID