APPS.INV_VIEW_MTL_TXN SQL Statements

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

Line: 130

       SELECT (MP.organization_code||'-'||HAOU.name)
         INTO x_owning_organization_name
         FROM HR_ALL_ORGANIZATION_UNITS HAOU
            , MTL_PARAMETERS MP
         WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
         AND   HAOU.ORGANIZATION_ID = p_owning_organization_id;

Line: 144

       SELECT (pov.vendor_name||'-'||povs.vendor_site_code)
         INTO x_owning_organization_name
         FROM po_vendor_sites_all povs, po_vendors POV
         WHERE povs.vendor_site_id = p_owning_organization_id
         AND povs.vendor_id = pov.vendor_id;

Line: 162

       SELECT (MP.organization_code||'-'||HAOU.name)
         INTO x_xfr_owning_organization_name
         FROM HR_ALL_ORGANIZATION_UNITS HAOU
            , MTL_PARAMETERS MP
         WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
         AND   HAOU.ORGANIZATION_ID = p_xfr_owning_organization_id;

Line: 176

       SELECT (pov.vendor_name||'-'||povs.vendor_site_code)
         INTO x_xfr_owning_organization_name
         FROM po_vendor_sites_all povs, po_vendors POV
         WHERE povs.vendor_site_id = p_xfr_owning_organization_id
         AND povs.vendor_id = pov.vendor_id;

Line: 189

       SELECT (MP.organization_code||'-'||HAOU.name), NULL
         INTO x_supplier_site_name, x_supplier
         FROM HR_ALL_ORGANIZATION_UNITS HAOU
            , MTL_PARAMETERS MP
         WHERE HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
         AND HAOU.ORGANIZATION_ID = p_planning_organization_id;

Line: 204

       SELECT (pov.vendor_name||'-'||povs.vendor_site_code),pov.vendor_name
         INTO x_supplier_site_name, x_supplier
         FROM po_vendor_sites_all povs, po_vendors POV
         WHERE povs.vendor_site_id = p_planning_organization_id
         AND povs.vendor_id = pov.vendor_id;

Line: 218

      SELECT TRANSACTION_TYPE_NAME
       INTO x_TRANSACTION_TYPE_NAME
       FROM MTL_TRANSACTION_TYPES
       WHERE TRANSACTION_TYPE_ID = p_TRANSACTION_TYPE_ID;

Line: 230

        SELECT MEANING
        INTO x_TRANSACTION_ACTION
        FROM  MFG_LOOKUPS
        WHERE LOOKUP_TYPE    ='MTL_TRANSACTION_ACTION'
         AND LOOKUP_CODE =p_TRANSACTION_ACTION_ID;

Line: 242

         SELECT MEANING,LOOKUP_CODE
         INTO x_COSTED_FLAG_1,
              x_COSTED_LOOKUP_CODE
         FROM  MFG_LOOKUPS
         WHERE LOOKUP_TYPE ='INV_YES_NO_ERROR'
           AND LOOKUP_CODE =DECODE(p_COSTED_FLAG,NULL,1,'Y',1,'N',2,'E',3);

Line: 253

         SELECT MEANING,LOOKUP_CODE
         INTO x_PM_COST_COLLECTED_1,
              x_PM_COST_COLLECTED_LK_CODE
         FROM  MFG_LOOKUPS
         WHERE LOOKUP_TYPE ='INV_YES_NO_ERROR_NA'
           AND LOOKUP_CODE =DECODE (p_PM_COST_COLLECTED, NULL,
                                            DECODE(p_PM_COST_COLLECTOR_GROUP_ID,
                                                   NULL,4,1),
                                                    'Y', 1,
                                                    'N', 2,
                                                    'E', 3
                                    );

Line: 272

           SELECT TRANSACTION_SOURCE_TYPE_NAME,
                 TRANSACTION_SOURCE_TYPE_NAME
           INTO x_TRANSACTION_SOURCE_TYPE_NAME,
                x_TRANSACTION_SOURCE_NAME_DB
           FROM  mtl_txn_source_types
           WHERE TRANSACTION_SOURCE_TYPE_ID =p_TRANSACTION_SOURCE_TYPE_ID  ;

Line: 286

          SELECT REASON_NAME
          INTO x_REASON_NAME
          FROM MTL_TRANSACTION_REASONS
          WHERE REASON_ID =p_REASON_ID;

Line: 298

            SELECT DEPARTMENT_CODE
            INTO x_DEPARTMENT_CODE
            FROM BOM_DEPARTMENTS
            WHERE DEPARTMENT_ID =p_DEPARTMENT_ID;

Line: 311

             SELECT DISTINCT ORGANIZATION_CODE
             INTO x_TRANSFER_ORGANIZATION_NAME
             FROM MTL_PARAMETERS
             WHERE ORGANIZATION_ID = p_TRANSFER_ORGANIZATION_ID;

Line: 326

           SELECT OOD. ORGANIZATION_NAME, HOU.NAME
           INTO X_ORGANIZATION_CODE , X_OPERATING_UNIT
           FROM ORG_ORGANIZATION_DEFINITIONS OOD, HR_OPERATING_UNITS HOU
           WHERE OOD.ORGANIZATION_ID = P_ORGANIZATION_ID AND
           OOD.OPERATING_UNIT = HOU.ORGANIZATION_ID;

Line: 344

              SELECT LICENSE_PLATE_NUMBER
		INTO x_LPN
		FROM WMS_LICENSE_PLATE_NUMBERS
		WHERE LPN_ID = p_LPN_ID  ;

Line: 356

        SELECT LICENSE_PLATE_NUMBER
        INTO x_TRANSFER_LPN
        FROM WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = p_TRANSFER_LPN_ID  ;

Line: 367

        SELECT LICENSE_PLATE_NUMBER
        INTO x_CONTENT_LPN
        FROM WMS_LICENSE_PLATE_NUMBERS
        WHERE LPN_ID = p_CONTENT_LPN_ID  ;

Line: 378

          SELECT COST_GROUP
          INTO x_COST_GROUP_NAME
          FROM CST_COST_GROUPS
          WHERE COST_GROUP_ID = p_COST_GROUP_ID;

Line: 389

          SELECT COST_GROUP
          INTO x_TRANSFER_COST_GROUP_NAME
          FROM CST_COST_GROUPS
          WHERE COST_GROUP_ID = p_TRANSFER_COST_GROUP_ID;

Line: 401

	select name
	into x_put_away_strategy_name
	from wms_strategies
	where strategy_id = p_put_away_strategy_id;

Line: 410

	select name
	into x_put_away_rule_name
	from wms_rules
	where rule_id = p_put_away_rule_id;

Line: 417

	select name
	into x_pick_strategy_name
	from wms_strategies
	where strategy_id = p_pick_strategy_id;

Line: 425

	select name
	into x_pick_rule_name
	from wms_rules
	where rule_id = p_pick_rule_id;