APPS.QA_SS_OSP SQL Statements

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

Line: 144

        SELECT Assembly_Item_Number, Vendor_Name, Wip_Entity_Name,
                     Base_Po_Num, Supplier_Item_Number,
                     Wip_Operation_Seq_Num, Assembly_Primary_UOM,
                     Wip_Line_code, Assembly_Quantity_Ordered,
                     Assembly_Item_Revision, Po_Release_Number,
                     Po_Header_Id, Po_Release_Id, Assembly_Item_Id,
                     Wip_Entity_Type, Wip_Repetitive_Schedule_Id,
                     Po_Line_Id, Line_Location_Id,
                     Po_Distribution_Id, Wip_Entity_Id,
                     Wip_Line_Id, Organization_Id
         FROM  WIP_ICX_OSP_WORKBENCH_V
            Where Po_Distribution_Id = to_number(PK1);

Line: 158

        SELECT AGENT_ID
        FROM PO_HEADERS_ALL
        where po_header_id = p_h_id;

Line: 163

        SELECT AGENT_ID
         FROM PO_RELEASES_ALL
         where PO_RELEASE_ID = p_rel_id;

Line: 257

        SELECT Assembly_Item_Number, Vendor_Name, Wip_Entity_Name,
                     Base_Po_Num, Supplier_Item_Number,
                     Wip_Operation_Seq_Num, Assembly_Primary_UOM,
                     Wip_Line_code, Assembly_Quantity_Ordered,
                     Assembly_Item_Revision, Po_Release_Number,
                    Organization_Id
         FROM  WIP_ICX_OSP_WORKBENCH_V
            Where Po_Distribution_Id = to_number(PK1);