eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AM_ASSET_RETURN_WF dependencies on OKL_ASSET_RETURNS_B

Line 333: OKL_ASSET_RETURNS_B OAR

329: OKC.CONTRACT_NUMBER CONTRACT_NUMBER, KLE.NAME ASSET_NUMBER,
330: OAR.DATE_RETURNED DATE_RETURNED, KLE.ID KLE_ID, OAR.RNA_ID AGENT_ID
331: FROM OKL_K_LINES_FULL_V KLE,
332: OKC_K_HEADERS_B OKC,
333: OKL_ASSET_RETURNS_B OAR
334: WHERE OKC.ID = KLE.CHR_ID
335: AND OAR.KLE_ID = KLE.ID
336: AND oar.id = c_art_id
337: AND ART1_CODE ='REPOS_REQUEST';

Line 1101: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE

1097: -- Check that the asset return refers to a Repossession Request
1098: CURSOR okl_check_req_csr(c_art_id NUMBER)
1099: IS
1100: SELECT OAR.KLE_ID KLE_ID, KLE.CHR_ID CHR_ID, OAR.LAST_UPDATED_BY LAST_UPDATED_BY
1101: FROM okl_asset_returns_b OAR, OKL_K_LINES_FULL_V KLE
1102: WHERE OAR.KLE_ID = KLE.ID
1103: AND OAR.ID= c_art_id;
1104:
1105: l_art_rec okl_check_req_csr%rowtype;

Line 1323: FROM okl_asset_returns_b ar

1319: -- Check that the asset return refers to a Repossession Request
1320: CURSOR okl_check_req_csr(c_art_id NUMBER)
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

Line 1780: FROM OKL_ASSET_RETURNS_B OAR,

1776: ACNT.PART_NAME PART_NAME,
1777: ACNT.RECOMMENDED_REPAIR DETAILS,
1778: FND1.MEANING CONDITION_TYPE,
1779: FND2.MEANING DAMAGE_TYPE
1780: FROM OKL_ASSET_RETURNS_B OAR,
1781: OKC_K_HEADERS_ALL_B OKC,
1782: OKC_K_LINES_V KLE,
1783: OKL_ASSET_CNDTNS_ALL ACD,
1784: OKL_AST_CNDTN_LNS_ALL_B ACNB,