APPS.WIP_GLOBALS SQL Statements

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

Line: 20

    FND_API.g_entity_tbl.DELETE;

Line: 85

    ELSIF p_action = G_OPR_UPDATE THEN

        l_control_rec.default_attributes:=   FALSE;

Line: 96

    ELSIF p_action = G_OPR_DELETE THEN

        l_control_rec.default_attributes:=   FALSE;

Line: 261

SELECT  STOCK_LOCATOR_CONTROL_CODE
FROM    MTL_PARAMETERS
WHERE   ORGANIZATION_ID = p_org_id;

Line: 266

SELECT  Location_Control_Code
FROM  mtl_system_items
WHERE  inventory_item_id = p_primary_item_id
AND    ORGANIZATION_ID = p_org_id;

Line: 272

SELECT  LOCATOR_TYPE
FROM  mtl_secondary_inventories
WHERE  ORGANIZATION_ID = p_org_id
AND    SECONDARY_INVENTORY_NAME = p_subinventory_code;

Line: 325

   Select USE_PHANTOM_ROUTINGS
   INTO   x_use_phantom_routings
   FROM   BOM_PARAMETERS
   WHERE  organization_Id = p_org_id;

Line: 348

   Select INHERIT_PHANTOM_OP_SEQ
   INTO   x_inherit_phantom_op_seq
   FROM   BOM_PARAMETERS
   WHERE  organization_Id = p_org_id;