DBA Data[Home] [Help]

APPS.INV_RCV_CACHE SQL Statements

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

Line: 130

	 SELECT primary_uom_code
	   ,    secondary_uom_code
	   ,    lot_control_code
	   ,    serial_number_control_code
	   INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
	   FROM   mtl_system_items
	   WHERE  organization_id = p_organization_id
	   AND    inventory_item_id = p_inventory_item_id;
Line: 191

	 SELECT primary_uom_code
	   ,    secondary_uom_code
	   ,    lot_control_code
	   ,    serial_number_control_code
	   INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
	   FROM   mtl_system_items
	   WHERE  organization_id = p_organization_id
	   AND    inventory_item_id = p_inventory_item_id;
Line: 252

	 SELECT primary_uom_code
	   ,    secondary_uom_code
	   ,    lot_control_code
	   ,    serial_number_control_code
	   INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
	   FROM   mtl_system_items
	   WHERE  organization_id = p_organization_id
	   AND    inventory_item_id = p_inventory_item_id;
Line: 313

	 SELECT primary_uom_code
	   ,    secondary_uom_code
	   ,    lot_control_code
	   ,    serial_number_control_code
	   INTO g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).primary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).secondary_uom_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).lot_control_code
	   ,    g_org_item_attrib_tb(p_organization_id)(p_inventory_item_id).serial_number_control_code
	   FROM   mtl_system_items
	   WHERE  organization_id = p_organization_id
	   AND    inventory_item_id = p_inventory_item_id;