DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_REQUISITION_HEADERS_ALL

Line 1507: FROM po_requisition_headers_all prh,

1503: prl.need_by_date old_need_by_date,
1504: prl.wip_operation_seq_num wip_op_seq,
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'

Line 2099: po_requisition_headers_all prh,

2095: prh.authorization_status approval_status,
2096: msi.primary_uom_code uom_code,
2097: prl.org_id ou_id -- operating unit
2098: FROM mtl_system_items msi,
2099: po_requisition_headers_all prh,
2100: po_requisition_lines_all prl,
2101: wip_operation_resources wor,
2102: wip_operations wo,
2103: wip_discrete_jobs wdj,

Line 2499: FROM po_requisition_headers_all prh,

2495: prh.authorization_status approval_status,
2496: to_char(null) document_type,
2497: to_char(null) document_subtype,
2498: prl.org_id ou_id -- operating unit
2499: FROM po_requisition_headers_all prh,
2500: po_requisition_lines_all prl
2501: WHERE NOT EXISTS
2502: (SELECT 'x'
2503: FROM po_line_locations_all pll