DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_LINES_ALL

Line 1356: po_lines_all pl,

1352: pl.item_id item_id,
1353: pd.org_id ou_id -- operating unit
1354: FROM po_distributions_all pd,
1355: po_headers_all ph,
1356: po_lines_all pl,
1357: po_line_locations_all pll,
1358: po_line_types plt
1359: WHERE ph.type_lookup_code = 'STANDARD'
1360: AND ph.po_header_id = pd.po_header_id

Line 1388: po_lines_all pl,

1384: pl.item_id item_id,
1385: pd.org_id ou_id -- operating unit
1386: FROM po_distributions_all pd,
1387: po_headers_all ph,
1388: po_lines_all pl,
1389: po_line_locations_all pll,
1390: po_releases_all pr,
1391: po_line_types plt
1392: WHERE ph.type_lookup_code = 'BLANKET'

Line 1735: po_lines_all pl,

1731: -- time and throw the multiple PO error appropriately.
1732: CURSOR c_multiple_po IS
1733: SELECT count(*)
1734: FROM po_distributions_all pd,
1735: po_lines_all pl,
1736: po_headers_all ph,
1737: po_releases_all pr,
1738: po_line_locations_all pll,
1739: wip_discrete_jobs wdj, -- bugfix 5000087

Line 1847: po_lines_all pl,

1843: pd.org_id ou_id -- operating unit
1844: FROM mtl_system_items msi,
1845: po_distributions_all pd,
1846: po_headers_all ph,
1847: po_lines_all pl,
1848: po_line_locations_all pll,
1849: wip_operation_resources wor,
1850: wip_operations wo,
1851: wip_discrete_jobs wdj,

Line 1910: po_lines_all pl,

1906: pd.org_id ou_id -- operating unit
1907: FROM mtl_system_items msi,
1908: po_distributions_all pd,
1909: po_headers_all ph,
1910: po_lines_all pl,
1911: po_line_locations_all pll,
1912: po_releases_all pr,
1913: wip_operation_resources wor,
1914: wip_operations wo,