APPS.OKL_SSC_WF dependencies on OKL_TXL_ASSETS_B

Line 215: select asset_number from okl_txl_assets_b

211:
212:
213:
214: CURSOR returned_assets(p_tas_id NUMBER, p_tal_type varchar2) IS
215: select asset_number from okl_txl_assets_b
216: where tas_id = p_tas_id
217: and tal_type = p_tal_type
218: ;
219:

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 698: OKL_TXL_ASSETS_B ASX,

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
700: where
701: INX.TAS_ID = p_tas_id
702: AND INX.TAL_TYPE = p_tal_type