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 876: 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

872: l_loc_rec OKL_BLK_AST_UPD_PUB.blk_rec_type;
873: l_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
874: x_trxv_rec OKL_TRX_ASSETS_PUB.thpv_rec_type;
875:
876: 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
877: SELECT
878: PARTY_SITE_ID,
879: LOCATION_ID
880: FROM okx_party_site_uses_v

Line 1079: FROM OKL_TXL_ITM_INSTS

1075: KLE_ID,
1076: SERIAL_NUMBER,
1077: instance_number_ib,
1078: INVENTORY_ITEM_ID
1079: FROM OKL_TXL_ITM_INSTS
1080: WHERE TAS_ID = p_tas_id;
1081:
1082: CURSOR okl_inst_csr (p_kle_id IN NUMBER) IS
1083: SELECT

Line 1210: FROM OKL_TXL_ITM_INSTS

1206: OBJECT_ID1_NEW,
1207: OBJECT_ID2_NEW,
1208: instance_number_ib,
1209: INVENTORY_ITEM_ID
1210: FROM OKL_TXL_ITM_INSTS
1211: WHERE TAS_ID = p_tas_id;
1212:
1213: 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
1214: SELECT

Line 1213: 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

1209: INVENTORY_ITEM_ID
1210: FROM OKL_TXL_ITM_INSTS
1211: WHERE TAS_ID = p_tas_id;
1212:
1213: 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
1214: SELECT
1215: PARTY_SITE_ID,
1216: LOCATION_ID
1217: FROM okx_party_site_uses_v

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

1216: LOCATION_ID
1217: FROM okx_party_site_uses_v
1218: WHERE ID1 = p_id1 AND ID2 = p_id2;
1219:
1220: CURSOR okl_inst_csr (p_kle_id IN OKL_TXL_ITM_INSTS.KLE_ID%TYPE) IS
1221: SELECT
1222: KIT.OBJECT1_ID1
1223: FROM OKC_K_ITEMS KIT
1224: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE

Line 1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;

1245: l_txn_rec transaction_rec;
1246: l_instance_id_lst id_tbl;
1247:
1248:
1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;

Line 1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;

1246: l_instance_id_lst id_tbl;
1247:
1248:
1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1254: BEGIN

Line 1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;

1247:
1248:
1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1254: BEGIN
1255:

Line 1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;

1248:
1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1254: BEGIN
1255:
1256: If p_tas_id is not null Then

Line 1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;

1249: l_tas_id OKL_TXL_ITM_INSTS.TAS_ID%TYPE;
1250: l_kle_id OKL_TXL_ITM_INSTS.KLE_ID%TYPE;
1251: l_id1_id OKL_TXL_ITM_INSTS.OBJECT_ID1_NEW%TYPE;
1252: l_id2_id OKL_TXL_ITM_INSTS.OBJECT_ID2_NEW%TYPE;
1253: l_object_version_number OKL_TXL_ITM_INSTS.object_version_number%TYPE;
1254: BEGIN
1255:
1256: If p_tas_id is not null Then
1257: l_tas_id := p_tas_id;