DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on OKL_TRX_ASSETS

Line 1358: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1354: OR (
1355: oast.ASSET_STATUS_CODE = 'ABANDONED'
1356: and exists (
1357: select 1
1358: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1359: where a.tas_id = b.id
1360: and b.tsu_code = 'PROCESSED'
1361: and c.tal_id = a.id
1362: and c.split_percent is not null

Line 1432: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1428: OR (
1429: oast.ASSET_STATUS_CODE = 'ABANDONED'
1430: and exists (
1431: select 1
1432: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1433: where a.tas_id = b.id
1434: and b.tsu_code = 'PROCESSED'
1435: and c.tal_id = a.id
1436: and c.split_percent is not null

Line 1505: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1501: OR (
1502: oast.ASSET_STATUS_CODE = 'ABANDONED'
1503: and exists (
1504: select 1
1505: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1506: where a.tas_id = b.id
1507: and b.tsu_code = 'PROCESSED'
1508: and c.tal_id = a.id
1509: and c.split_percent is not null

Line 1574: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1570: OR (
1571: oast.ASSET_STATUS_CODE = 'ABANDONED'
1572: and exists (
1573: select 1
1574: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1575: where a.tas_id = b.id
1576: and b.tsu_code = 'PROCESSED'
1577: and c.tal_id = a.id
1578: and c.split_percent is not null

Line 1645: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1641: OR (
1642: nast.ASSET_STATUS_CODE = 'ABANDONED'
1643: and exists (
1644: select 1
1645: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1646: where a.tas_id = b.id
1647: and b.tsu_code = 'PROCESSED'
1648: and c.tal_id = a.id
1649: and c.split_percent is not null

Line 1717: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1713: OR (
1714: nast.ASSET_STATUS_CODE = 'ABANDONED'
1715: and exists (
1716: select 1
1717: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1718: where a.tas_id = b.id
1719: and b.tsu_code = 'PROCESSED'
1720: and c.tal_id = a.id
1721: and c.split_percent is not null

Line 1786: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1782: OR (
1783: nast.ASSET_STATUS_CODE = 'ABANDONED'
1784: and exists (
1785: select 1
1786: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1787: where a.tas_id = b.id
1788: and b.tsu_code = 'PROCESSED'
1789: and c.tal_id = a.id
1790: and c.split_percent is not null

Line 1856: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d

1852: OR (
1853: nast.ASSET_STATUS_CODE = 'ABANDONED'
1854: and exists (
1855: select 1
1856: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1857: where a.tas_id = b.id
1858: and b.tsu_code = 'PROCESSED'
1859: and c.tal_id = a.id
1860: and c.split_percent is not null