DBA Data[Home] [Help]

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: 730

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

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

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

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

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

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

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

                   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: 789

                   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: 795

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

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

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

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

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

                   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: 868

                   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: 874

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

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

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

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

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

                   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: 947

                   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: 953

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

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

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

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

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

                   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: 1026

                   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: 1032

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

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

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

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

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

                   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: 1105

                   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: 1111

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