DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_REQUISITION_HEADERS_ALL

Line 1421: FROM po_requisition_headers_all prh,

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

Line 1978: po_requisition_headers_all prh,

1974: prh.authorization_status approval_status,
1975: msi.primary_uom_code uom_code,
1976: prl.org_id ou_id -- operating unit
1977: FROM mtl_system_items msi,
1978: po_requisition_headers_all prh,
1979: po_requisition_lines_all prl,
1980: wip_operation_resources wor,
1981: wip_operations wo,
1982: wip_discrete_jobs wdj,

Line 2338: FROM po_requisition_headers_all prh,

2334: prh.authorization_status approval_status,
2335: to_char(null) document_type,
2336: to_char(null) document_subtype,
2337: prl.org_id ou_id -- operating unit
2338: FROM po_requisition_headers_all prh,
2339: po_requisition_lines_all prl
2340: WHERE NOT EXISTS
2341: (SELECT 'x'
2342: FROM po_line_locations_all pll