APPS.WIP_OSP dependencies on PO_REQUISITION_LINES_ALL

Line 931: FROM PO_REQUISITION_LINES_ALL PRL

927: AND (PLL.QUANTITY_RECEIVED < (PLL.QUANTITY-PLL.QUANTITY_CANCELLED))
928: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
929: UNION ALL
930: SELECT 'PO/REQ Linked'
931: FROM PO_REQUISITION_LINES_ALL PRL
932: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
933: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
934: AND (p_op_seq_num is NULL OR
935: PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num)

Line 974: FROM PO_REQUISITION_LINES_ALL PRL

970: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
971: -- nvl(PR.CANCEL_FLAG, 'N') = 'N'))
972: UNION ALL
973: SELECT 'PO/REQ Linked'
974: FROM PO_REQUISITION_LINES_ALL PRL
975: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
976: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
977: AND PRL.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
978: AND (p_op_seq_num is NULL OR

Line 1422: po_requisition_lines_all prl,

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'
1426: FROM po_line_locations_all pll

Line 1784: FROM po_requisition_lines_all prl,

1780: pl.item_id
1781: HAVING count(*) > 1
1782: UNION ALL
1783: SELECT count(*)
1784: FROM po_requisition_lines_all prl,
1785: wip_discrete_jobs wdj, -- bugfix 5000087
1786: wip_repetitive_schedules wrs, -- bugfix 5000087
1787: wip_operations wo -- bugfix 5000087
1788: WHERE prl.wip_entity_id = p_job_id

Line 1979: po_requisition_lines_all prl,

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,
1983: wip_repetitive_schedules wrs

Line 2166: -- Call PO API to update QUANTITY in PO_REQUISITION_LINES_ALL.

2162: l_errMsg := 'PO is in status that does not allow update';
2163: raise fnd_api.g_exc_unexpected_error;
2164: END IF; -- Check PO status
2165: ELSIF (l_update_po_qty.po_req_type = 'REQUISITION') THEN
2166: -- Call PO API to update QUANTITY in PO_REQUISITION_LINES_ALL.
2167: l_req_changes := PO_REQ_CHANGES_REC_TYPE(
2168: req_header_id => l_update_po_qty.req_header_id,
2169: line_changes => NULL,
2170: distribution_changes => NULL);

Line 2339: po_requisition_lines_all prl

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
2343: WHERE prl.line_location_id = pll.line_location_id)

Line 2539: FROM PO_REQUISITION_LINES_ALL PRL

2535: AND PH.PO_HEADER_ID = PD.PO_HEADER_ID
2536: AND PR.PO_RELEASE_ID (+) = PD.PO_RELEASE_ID)
2537: AND NOT EXISTS
2538: (SELECT '1'
2539: FROM PO_REQUISITION_LINES_ALL PRL
2540: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
2541: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
2542: AND (p_op_seq_num is NULL
2543: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))