DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_LINE_TYPES

Line 1358: po_line_types plt

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

Line 1391: po_line_types plt

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'
1393: AND pr.po_release_id = pll.po_release_id
1394: AND pr.po_header_id = ph.po_header_id
1395: AND ph.po_header_id = pd.po_header_id

Line 1423: po_line_types plt

1419: prl.item_id item_id,
1420: prl.org_id ou_id -- operating unit
1421: FROM po_requisition_headers_all prh,
1422: po_requisition_lines_all prl,
1423: po_line_types plt
1424: WHERE NOT EXISTS
1425: (SELECT 'x'
1426: FROM po_line_locations_all pll
1427: WHERE prl.line_location_id = pll.line_location_id)