APPS.INV_INVTRDST_XMLP_PKG SQL Statements

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

Line: 11

        SELECT
          TRANSACTION_SOURCE_TYPE_NAME
        INTO SOURCE_TYPE_NAME
        FROM
          MTL_TXN_SOURCE_TYPES
        WHERE TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE_ID;

Line: 106

                   ,'Failed in MSTK/Select')*/NULL;

Line: 114

                   ,'Failed in GL#/Select')*/NULL;

Line: 351

        SELECT
          CATEGORY_SET_NAME
        INTO CAT_SET_NAME
        FROM
          MTL_CATEGORY_SETS
        WHERE CATEGORY_SET_ID = CAT_SET_ID;

Line: 375

        SELECT
          TRANSACTION_TYPE_NAME
        INTO TXN_TYPE_NAME
        FROM
          MTL_TRANSACTION_TYPES
        WHERE TRANSACTION_TYPE_ID = TXN_TYPE_ID;

Line: 399

        SELECT
          REASON_NAME
        INTO REASON_NAME
        FROM
          MTL_TRANSACTION_REASONS
        WHERE REASON_ID = TXN_REASON_ID;

Line: 517

        RETURN ('cst_cost_updates cst,');

Line: 814

          RETURN ('and mta.transaction_source_id = CST.cost_update_id
                 	and CST.description between ''' || P_SOURCE_LO || ''' and ''' || P_SOURCE_HI || ''' ');

Line: 817

          RETURN ('and mta.transaction_source_id = CST.cost_update_id
                 	and CST.description between >= ''' || P_SOURCE_LO || ''' ');

Line: 820

          RETURN ('and mta.transaction_source_id = CST.cost_update_id
                 	and CST.description <= ''' || P_SOURCE_HI || ''' ');

Line: 847

if Type_id = 1 then select segment1 into txn_source
                          from po_headers_all
                          where  po_header_id = to_number(txn_source_id);

Line: 852

			select request_number into txn_source
			from mtl_txn_request_headers
			where header_id = to_number(txn_source_id);

Line: 857

                          select wip_entity_name into txn_source
                          from wip_entities
                          where wip_entity_id = to_number(txn_source_id);

Line: 861

elsif Type_id = 7 then select segment1 into txn_source
                                    from po_requisition_headers_all
                                    where requisition_header_id =
                                          txn_source_id;

Line: 867

                   select CYCLE_COUNT_HEADER_NAME into txn_source
                   from mtl_cycle_count_headers
                   where cycle_count_header_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 873

                   select physical_inventory_name into txn_source
                   from  mtl_physical_inventories
                   where physical_inventory_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 879

                      select description into txn_source
                      from  cst_cost_updates
                      where cost_update_id = to_number(txn_source_id);

Line: 926

if Type_id1 = 1 then select segment1 into txn_source
                          from po_headers_all
                          where  po_header_id = to_number(txn_source_id);

Line: 931

			select request_number into txn_source
			from mtl_txn_request_headers
			where header_id = to_number(txn_source_id);

Line: 936

                          select wip_entity_name into txn_source
                          from wip_entities
                          where wip_entity_id = to_number(txn_source_id);

Line: 940

elsif Type_id1 = 7 then select segment1 into txn_source
                                    from po_requisition_headers_all
                                    where requisition_header_id =
                                          txn_source_id;

Line: 946

                   select CYCLE_COUNT_HEADER_NAME into txn_source
                   from mtl_cycle_count_headers
                   where cycle_count_header_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 952

                   select physical_inventory_name into txn_source
                   from  mtl_physical_inventories
                   where physical_inventory_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 958

                      select description into txn_source
                      from  cst_cost_updates
                      where cost_update_id = to_number(txn_source_id);

Line: 1005

if Type_id2 = 1 then select segment1 into txn_source
                          from po_headers_all
                          where  po_header_id = to_number(txn_source_id);

Line: 1010

			select request_number into txn_source
			from mtl_txn_request_headers
			where header_id = to_number(txn_source_id);

Line: 1015

                          select wip_entity_name into txn_source
                          from wip_entities
                          where wip_entity_id = to_number(txn_source_id);

Line: 1019

elsif Type_id2 = 7 then select segment1 into txn_source
                                    from po_requisition_headers_all
                                    where requisition_header_id =
                                          txn_source_id;

Line: 1025

                   select CYCLE_COUNT_HEADER_NAME into txn_source
                   from mtl_cycle_count_headers
                   where cycle_count_header_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1031

                   select physical_inventory_name into txn_source
                   from  mtl_physical_inventories
                   where physical_inventory_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1037

                      select description into txn_source
                      from  cst_cost_updates
                      where cost_update_id = to_number(txn_source_id);

Line: 1084

if Type_id3 = 1 then select segment1 into txn_source
                          from po_headers_all
                          where  po_header_id = to_number(txn_source_id);

Line: 1089

			select request_number into txn_source
			from mtl_txn_request_headers
			where header_id = to_number(txn_source_id);

Line: 1094

                          select wip_entity_name into txn_source
                          from wip_entities
                          where wip_entity_id = to_number(txn_source_id);

Line: 1098

elsif Type_id3 = 7 then select segment1 into txn_source
                                    from po_requisition_headers_all
                                    where requisition_header_id =
                                          txn_source_id;

Line: 1104

                   select CYCLE_COUNT_HEADER_NAME into txn_source
                   from mtl_cycle_count_headers
                   where cycle_count_header_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1110

                   select physical_inventory_name into txn_source
                   from  mtl_physical_inventories
                   where physical_inventory_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1116

                      select description into txn_source
                      from  cst_cost_updates
                      where cost_update_id = to_number(txn_source_id);

Line: 1163

if Type_id4 = 1 then select segment1 into txn_source
                          from po_headers_all
                          where  po_header_id = to_number(txn_source_id);

Line: 1168

			select request_number into txn_source
			from mtl_txn_request_headers
			where header_id = to_number(txn_source_id);

Line: 1173

                          select wip_entity_name into txn_source
                          from wip_entities
                          where wip_entity_id = to_number(txn_source_id);

Line: 1177

elsif Type_id4 = 7 then select segment1 into txn_source
                                    from po_requisition_headers_all
                                    where requisition_header_id =
                                          txn_source_id;

Line: 1183

                   select CYCLE_COUNT_HEADER_NAME into txn_source
                   from mtl_cycle_count_headers
                   where cycle_count_header_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1189

                   select physical_inventory_name into txn_source
                   from  mtl_physical_inventories
                   where physical_inventory_id = to_number(txn_source_id)
                   and   organization_id = org_id;

Line: 1195

                      select description into txn_source
                      from  cst_cost_updates
                      where cost_update_id = to_number(txn_source_id);