DBA Data[Home] [Help]

APPS.WIP_OSP dependencies on PO_REQUISITION_LINES_ALL

Line 1006: FROM PO_REQUISITION_LINES_ALL PRL

1002: AND (PLL.QUANTITY_RECEIVED < (PLL.QUANTITY-PLL.QUANTITY_CANCELLED))
1003: AND nvl(pll.closed_code,'OPEN') <> 'FINALLY CLOSED'
1004: UNION ALL
1005: SELECT 'PO/REQ Linked'
1006: FROM PO_REQUISITION_LINES_ALL PRL
1007: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
1008: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
1009: AND (p_op_seq_num is NULL OR
1010: PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num)

Line 1050: FROM PO_REQUISITION_LINES_ALL PRL

1046: -- (PH.TYPE_LOOKUP_CODE = 'BLANKET' AND
1047: -- nvl(PR.CANCEL_FLAG, 'N') = 'N'))
1048: UNION ALL
1049: SELECT 'PO/REQ Linked'
1050: FROM PO_REQUISITION_LINES_ALL PRL
1051: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
1052: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
1053: AND PRL.WIP_REPETITIVE_SCHEDULE_ID = p_rep_sched_id
1054: AND (p_op_seq_num is NULL OR

Line 1508: po_requisition_lines_all prl,

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

Line 1877: FROM po_requisition_lines_all prl,

1873: pl.item_id
1874: HAVING count(*) > 1
1875: UNION ALL
1876: SELECT count(*)
1877: FROM po_requisition_lines_all prl,
1878: wip_discrete_jobs wdj, -- bugfix 5000087
1879: wip_repetitive_schedules wrs, -- bugfix 5000087
1880: wip_operations wo -- bugfix 5000087
1881: WHERE prl.wip_entity_id = p_job_id

Line 2100: po_requisition_lines_all prl,

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

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

2295: l_errMsg := 'PO is in status that does not allow update';
2296: raise fnd_api.g_exc_unexpected_error;
2297: END IF; -- Check PO status
2298: ELSIF (l_update_po_qty.po_req_type = 'REQUISITION') THEN
2299: -- Call PO API to update QUANTITY in PO_REQUISITION_LINES_ALL.
2300: l_req_changes := PO_REQ_CHANGES_REC_TYPE(
2301: req_header_id => l_update_po_qty.req_header_id,
2302: line_changes => NULL,
2303: distribution_changes => NULL);

Line 2500: po_requisition_lines_all prl

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

Line 2701: FROM PO_REQUISITION_LINES_ALL PRL

2697: AND PH.PO_HEADER_ID = PD.PO_HEADER_ID
2698: AND PR.PO_RELEASE_ID (+) = PD.PO_RELEASE_ID)
2699: AND NOT EXISTS
2700: (SELECT '1'
2701: FROM PO_REQUISITION_LINES_ALL PRL
2702: WHERE PRL.WIP_ENTITY_ID = p_wip_entity_id
2703: AND PRL.DESTINATION_ORGANIZATION_ID = p_organization_id
2704: AND (p_op_seq_num is NULL
2705: OR PRL.WIP_OPERATION_SEQ_NUM = p_op_seq_num))