DBA Data[Home] [Help]

APPS.OKL_LA_ASSET_PVT dependencies on OKL_TXL_ASSETS_B

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

1382: OR (
1383: oast.ASSET_STATUS_CODE = 'ABANDONED'
1384: and exists (
1385: select 1
1386: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1387: where a.tas_id = b.id
1388: and b.tsu_code = 'PROCESSED'
1389: and c.tal_id = a.id
1390: and c.split_percent is not null

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

1456: OR (
1457: oast.ASSET_STATUS_CODE = 'ABANDONED'
1458: and exists (
1459: select 1
1460: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1461: where a.tas_id = b.id
1462: and b.tsu_code = 'PROCESSED'
1463: and c.tal_id = a.id
1464: and c.split_percent is not null

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

1529: OR (
1530: oast.ASSET_STATUS_CODE = 'ABANDONED'
1531: and exists (
1532: select 1
1533: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1534: where a.tas_id = b.id
1535: and b.tsu_code = 'PROCESSED'
1536: and c.tal_id = a.id
1537: and c.split_percent is not null

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

1598: OR (
1599: oast.ASSET_STATUS_CODE = 'ABANDONED'
1600: and exists (
1601: select 1
1602: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1603: where a.tas_id = b.id
1604: and b.tsu_code = 'PROCESSED'
1605: and c.tal_id = a.id
1606: and c.split_percent is not null

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

1669: OR (
1670: nast.ASSET_STATUS_CODE = 'ABANDONED'
1671: and exists (
1672: select 1
1673: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1674: where a.tas_id = b.id
1675: and b.tsu_code = 'PROCESSED'
1676: and c.tal_id = a.id
1677: and c.split_percent is not null

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

1741: OR (
1742: nast.ASSET_STATUS_CODE = 'ABANDONED'
1743: and exists (
1744: select 1
1745: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1746: where a.tas_id = b.id
1747: and b.tsu_code = 'PROCESSED'
1748: and c.tal_id = a.id
1749: and c.split_percent is not null

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

1810: OR (
1811: nast.ASSET_STATUS_CODE = 'ABANDONED'
1812: and exists (
1813: select 1
1814: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1815: where a.tas_id = b.id
1816: and b.tsu_code = 'PROCESSED'
1817: and c.tal_id = a.id
1818: and c.split_percent is not null

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

1880: OR (
1881: nast.ASSET_STATUS_CODE = 'ABANDONED'
1882: and exists (
1883: select 1
1884: FROM okl_txl_assets_b a, okl_trx_assets b, okl_txd_assets_b c,okl_trx_types_tl d
1885: where a.tas_id = b.id
1886: and b.tsu_code = 'PROCESSED'
1887: and c.tal_id = a.id
1888: and c.split_percent is not null