[Home] [Help]
223: IS
224: SELECT 'X'
225: FROM OKL_TRX_ASSETS TRX,
226: OKL_TXL_ITM_INSTS TXL,
227: OKL_TRX_TYPES_B TRY
228: WHERE TRX.ID = TXL.TAS_ID
229: AND TRX.TRY_ID = TRY.ID
230: AND TRY.TRX_TYPE_CLASS = 'ASSET_RELOCATION'
231: AND TRX.TSU_CODE = 'ENTERED'
1766: TXL.object_id1_old,object_id2_old,psu.location_id, psu.party_site_id,
1767: TRX.DATE_TRANS_OCCURRED,TRX.req_asset_id
1768: FROM OKL_TRX_ASSETS TRX,
1769: OKL_TXL_ITM_INSTS TXL,
1770: OKL_TRX_TYPES_B TRY,
1771: OKX_PARTY_SITE_USES_V psu
1772: WHERE TRX.ID = TXL.TAS_ID
1773: AND TRX.TRY_ID = TRY.ID
1774: AND TRY.TRX_TYPE_CLASS = 'ASSET_RELOCATION'