APPS.QA_SS_SHIP SQL Statements

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

Line: 36

        SELECT
            organization_id
        FROM inv_organization_name_v
        WHERE lower(organization_name) = lower(x_org_name);

Line: 41

        SELECT organization_id
        FROM ORG_ORGANIZATION_DEFINITIONS
        WHERE lower(organization_name) = lower(x_org_name);

Line: 177

        SELECT BASE_PO_NUM, LINE_NUMBER,
              PO_RELEASE_ID, SHIPMENT_NUMBER,
              Ship_To_Location_Code, Supplier_Item_Number,
              Quantity_Ordered, Unit_of_Measure_code,
              supplier_name, supplier_site_code,
              ship_to_organization_name,
              Item_Number, Item_Revision,
              Category, PO_HEADER_ID, Item_ID,    -- already selected po_release_id above
              Po_Line_Id, Po_Shipment_Id, Ship_To_Organization_Id
         FROM  pos_po_qa_shipments_v
            Where Po_Shipment_Id = to_number(PK1);

Line: 190

        SELECT RELEASE_NUM
        FROM PO_RELEASES_ALL
        WHERE PO_RELEASE_ID =  x_rel_id;

Line: 195

        SELECT AGENT_ID
        FROM PO_HEADERS_ALL
        where po_header_id = p_h_id;

Line: 200

        SELECT AGENT_ID
         FROM PO_RELEASES_ALL
         where PO_RELEASE_ID = p_rel_id;

Line: 302

        SELECT BASE_PO_NUM, LINE_NUMBER,
              PO_RELEASE_ID, SHIPMENT_NUMBER,
              Ship_To_Location_Code, Supplier_Item_Number,
              Quantity_Ordered, Unit_of_Measure_code,
              supplier_name, supplier_site_code,
              ship_to_organization_name,
              Item_Number, Item_Revision,
              Category, Ship_To_Organization_ID
         FROM  pos_po_qa_shipments_v
            Where Po_Shipment_Id = to_number(PK1);

Line: 314

        SELECT RELEASE_NUM
        FROM PO_RELEASES_ALL
        WHERE PO_RELEASE_ID =  x_rel_id;