DBA Data[Home] [Help]

APPS.AS_OPP_LINE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 398: FROM mtl_system_items

394:
395: CURSOR C_Inventory_Item_Exists (c_Inventory_Item_Id NUMBER,
396: c_Organization_Id NUMBER) IS
397: SELECT 'X'
398: FROM mtl_system_items
399: WHERE inventory_item_id = c_Inventory_Item_Id
400: and organization_id = c_Organization_Id;
401:
402: CURSOR C_Category_Item_Exists ( c_interest_type_id number,

Line 2891: FROM mtl_system_items

2887: IS
2888:
2889: CURSOR C_INVENTORY_ITEM_ID_Exists(c_inventory_item_id NUMBER) IS
2890: SELECT 'X'
2891: FROM mtl_system_items
2892: WHERE inventory_item_id = c_inventory_item_id;
2893:
2894: l_val VARCHAR2(1);
2895: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

Line 3541: FROM mtl_system_items

3537:
3538: CURSOR C_Inventory_Item_Exists (c_Inventory_Item_Id NUMBER,
3539: c_Organization_Id NUMBER) IS
3540: SELECT 'X'
3541: FROM mtl_system_items
3542: WHERE inventory_item_id = c_Inventory_Item_Id
3543: and organization_id = c_Organization_Id;
3544:
3545: CURSOR C_Category_Item_Exists ( c_product_category_id number,

Line 3552: MTL_SYSTEM_ITEMS_VL ITEMS,

3548: c_organization_id number) IS
3549: select 'x'
3550: FROM
3551: MTL_ITEM_CATEGORIES MIC,
3552: MTL_SYSTEM_ITEMS_VL ITEMS,
3553: ENI_PROD_DEN_HRCHY_PARENTS_V P
3554: WHERE
3555: MIC.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND
3556: MIC.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID AND