APPS.WIP_OSP dependencies on PO_LINE_TYPES

Line 1444: po_line_types plt

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
1447: AND pd.po_line_id = pl.po_line_id
1448: AND pd.line_location_id = pll.line_location_id

Line 1477: po_line_types plt

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'
1479: AND pr.po_release_id = pll.po_release_id
1480: AND pr.po_header_id = ph.po_header_id
1481: AND ph.po_header_id = pd.po_header_id

Line 1509: po_line_types plt

1505: prl.item_id item_id,
1506: prl.org_id ou_id -- operating unit
1507: FROM po_requisition_headers_all prh,
1508: po_requisition_lines_all prl,
1509: po_line_types plt
1510: WHERE NOT EXISTS
1511: (SELECT 'x'
1512: FROM po_line_locations_all pll
1513: WHERE prl.line_location_id = pll.line_location_id)