DBA Data[Home] [Help]

APPS.MRP_SCHEDULE_CONS_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 13

  SELECT segment1
    INTO disposition
    FROM PO_HEADERS_ALL
   WHERE po_header_id = X_disposition_id;
Line: 31

  SELECT segment1
    INTO disposition
    FROM PO_REQUISITION_HEADERS_ALL
   WHERE requisition_header_id = X_disposition_id;
Line: 49

  SELECT shipment_num
    INTO disposition
    FROM RCV_SHIPMENT_HEADERS
   WHERE shipment_header_id = X_disposition_id;
Line: 72

  SELECT wip_entity_name
    INTO disposition
    FROM WIP_ENTITIES
   WHERE wip_entity_id = X_disposition_id
     AND organization_id = X_organization_id;