DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_LINES_ALL

Line 1442: po_lines_all pl,

1438: pl.item_id item_id,
1439: pd.org_id ou_id -- operating unit
1440: FROM po_distributions_all pd,
1441: po_headers_all ph,
1442: po_lines_all pl,
1443: po_line_locations_all pll,
1444: po_line_types plt
1445: WHERE ph.type_lookup_code = 'STANDARD'
1446: AND ph.po_header_id = pd.po_header_id

Line 1474: po_lines_all pl,

1470: pl.item_id item_id,
1471: pd.org_id ou_id -- operating unit
1472: FROM po_distributions_all pd,
1473: po_headers_all ph,
1474: po_lines_all pl,
1475: po_line_locations_all pll,
1476: po_releases_all pr,
1477: po_line_types plt
1478: WHERE ph.type_lookup_code = 'BLANKET'

Line 1828: po_lines_all pl,

1824: -- time and throw the multiple PO error appropriately.
1825: CURSOR c_multiple_po IS
1826: SELECT count(*)
1827: FROM po_distributions_all pd,
1828: po_lines_all pl,
1829: po_headers_all ph,
1830: po_releases_all pr,
1831: po_line_locations_all pll,
1832: wip_discrete_jobs wdj, -- bugfix 5000087

Line 1955: po_lines_all pl,

1951: pd.org_id ou_id -- operating unit
1952: FROM mtl_system_items msi,
1953: po_distributions_all pd,
1954: po_headers_all ph,
1955: po_lines_all pl,
1956: po_line_locations_all pll,
1957: wip_operation_resources wor,
1958: wip_operations wo,
1959: wip_discrete_jobs wdj,

Line 2031: po_lines_all pl,

2027: pd.org_id ou_id -- operating unit
2028: FROM mtl_system_items msi,
2029: po_distributions_all pd,
2030: po_headers_all ph,
2031: po_lines_all pl,
2032: po_line_locations_all pll,
2033: po_releases_all pr,
2034: wip_operation_resources wor,
2035: wip_operations wo,