DBA Data[Home] [Help]

APPS.CSD_SOO_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 1254: FROM po_requisition_lines_all

1250: WHERE orchestration_id = c_orchestration_id;
1251:
1252: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1253: SELECT wip_entity_id
1254: FROM po_requisition_lines_all
1255: WHERE requisition_header_id = c_requisition_header_id;
1256:
1257: BEGIN
1258: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Entering Refresh_Purchase_Req...');

Line 1301: po_requisition_lines_all porl

1297: csd_repairs dra,
1298: wip_entities we,
1299: po_requisition_headers_all porh,
1300: csd_repair_job_xref xref,
1301: po_requisition_lines_all porl
1302: where
1303: dra.repair_line_id = xref.repair_line_id and
1304: porh.type_lookup_code = 'PURCHASE' and
1305: we.wip_entity_id = xref.wip_entity_id and

Line 1568: FROM po_requisition_lines_all

1564: WHERE orchestration_id = c_orchestration_id;
1565:
1566: CURSOR c_get_wip_entity_id(c_requisition_header_id NUMBER) IS
1567: SELECT wip_entity_id
1568: FROM po_requisition_lines_all
1569: WHERE requisition_header_id = c_requisition_header_id;
1570:
1571: CURSOR c_get_order_header_id(c_requisition_header_id NUMBER,
1572: c_repair_line_id NUMBER) IS