DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKL_TRX_ASSETS

Line 79: FROM okl_trx_Assets trx,

75: SELECT 'Y' a
76: FROM okl_txd_assets_b txd
77: WHERE NVL(UPPER(txd.asset_number),'-999999999999999') = UPPER(p_asset_number) -- RMUNJULU 3241502
78: AND EXISTS (SELECT NULL
79: FROM okl_trx_Assets trx,
80: okl_trx_types_tl ttyp,
81: okl_txl_assets_b txl
82: WHERE trx.id = txl.tas_id
83: AND trx.try_id = ttyp.id