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_SSC_WF dependencies on OKL_TXL_ITM_INSTS

Line 423: FROM OKL_TXL_ITM_INSTS INX, OKL_TXL_ASSETS_B ASX

419: CURSOR serial_nums(p_tas_id NUMBER, p_tal_type varchar2) IS
420: SELECT
421: DISTINCT ASX.ASSET_NUMBER,
422: INX.SERIAL_NUMBER
423: FROM OKL_TXL_ITM_INSTS INX, OKL_TXL_ASSETS_B ASX
424: WHERE INX.TAS_ID = p_tas_id
425: AND INX.TAL_TYPE = p_tal_type
426: AND ASX.KLE_ID = INX.DNZ_CLE_ID
427: ;

Line 695: from OKL_TXL_ITM_INSTS INX,

691: ASX.ASSET_NUMBER,
692: PSU1.DESCRIPTION OLD_LOCATION,
693: PSU2.DESCRIPTION NEW_LOCATION,
694: TRX.DATE_TRANS_OCCURRED EFFECTIVE_DATE
695: from OKL_TXL_ITM_INSTS INX,
696: OKX_PARTY_SITE_USES_V PSU1,
697: OKX_PARTY_SITE_USES_V PSU2,
698: OKL_TXL_ASSETS_B ASX,
699: OKL_TRX_ASSETS TRX

Line 736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,

732: l_asset_number OKC_K_LINES_V.NAME%TYPE;
733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,
737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
738: SELECT PSU.DESCRIPTION
739: FROM OKX_PARTY_SITE_USES_V PSU
740: WHERE PSU.ID1 = cp_id1

Line 737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS

733: l_old_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
734: l_new_location OKX_PARTY_SITE_USES_V.DESCRIPTION%TYPE;
735:
736: CURSOR c_get_location(cp_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE,
737: cp_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
738: SELECT PSU.DESCRIPTION
739: FROM OKX_PARTY_SITE_USES_V PSU
740: WHERE PSU.ID1 = cp_id1
741: AND PSU.ID2 = cp_id2;

Line 925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS

921: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
922: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
923: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
924:
925: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
926: SELECT
927: PARTY_SITE_ID,
928: LOCATION_ID
929: FROM okx_party_site_uses_v

Line 1165: FROM OKL_TXL_ITM_INSTS

1161: KLE_ID,
1162: SERIAL_NUMBER,
1163: instance_number_ib,
1164: INVENTORY_ITEM_ID
1165: FROM OKL_TXL_ITM_INSTS
1166: WHERE TAS_ID = p_tas_id;
1167:
1168: CURSOR okl_inst_csr (p_kle_id IN NUMBER) IS
1169: SELECT

Line 1296: FROM OKL_TXL_ITM_INSTS

1292: OBJECT_ID1_NEW,
1293: OBJECT_ID2_NEW,
1294: instance_number_ib,
1295: INVENTORY_ITEM_ID
1296: FROM OKL_TXL_ITM_INSTS
1297: WHERE TAS_ID = p_tas_id;
1298:
1299: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
1300: SELECT

Line 1299: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS

1295: INVENTORY_ITEM_ID
1296: FROM OKL_TXL_ITM_INSTS
1297: WHERE TAS_ID = p_tas_id;
1298:
1299: CURSOR okl_loc_csr (p_id1 IN OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE, p_id2 IN OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE) IS
1300: SELECT
1301: PARTY_SITE_ID,
1302: LOCATION_ID
1303: FROM okx_party_site_uses_v

Line 1306: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS

1302: LOCATION_ID
1303: FROM okx_party_site_uses_v
1304: WHERE ID1 = p_id1 AND ID2 = p_id2;
1305:
1306: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1307: SELECT
1308: KIT.OBJECT1_ID1
1309: FROM OKC_K_ITEMS KIT
1310: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE

Line 1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

1331: l_txn_rec transaction_rec;
1332: l_instance_id_lst id_tbl;
1333:
1334:
1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;

Line 1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;

1332: l_instance_id_lst id_tbl;
1333:
1334:
1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1340: BEGIN

Line 1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;

1333:
1334:
1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1340: BEGIN
1341:

Line 1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;

1334:
1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1340: BEGIN
1341:
1342: If p_tas_id is not null Then

Line 1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;

1335: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1336: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1337: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1338: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1339: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1340: BEGIN
1341:
1342: If p_tas_id is not null Then
1343: l_tas_id := p_tas_id;