APPS.OE_ORDER_CACHE dependencies on MTL_SYSTEM_ITEMS

Line 1517: FROM mtl_system_items

1513: , grade_ctl
1514: FROM ic_item_mst
1515: WHERE delete_mark = 0
1516: AND item_no in (SELECT segment1
1517: FROM mtl_system_items
1518: WHERE organization_id = discrete_org_id
1519: AND inventory_item_id = discrete_item_id);
1520: --OPM 02/JUN/00 END
1521: --=================

Line 1550: OE_DEBUG_PUB.ADD('querying item from mtl_system_items', 3);

1546: IF g_item_rec.inventory_item_id = FND_API.G_MISS_NUM OR
1547: g_item_rec.inventory_item_id <> p_key1 THEN
1548:
1549: if l_debug_level > 0 then
1550: OE_DEBUG_PUB.ADD('querying item from mtl_system_items', 3);
1551: end if;
1552:
1553: /* Always load values based on the validation org
1554: for the below attributes. In future please add here for the columns

Line 1619: FROM MTL_SYSTEM_ITEMS

1615: ,g_item_rec.secondary_default_ind
1616: ,g_item_rec.lot_divisible_flag
1617: ,g_item_rec.grade_control_flag
1618: ,g_item_rec.lot_control_code
1619: FROM MTL_SYSTEM_ITEMS
1620: WHERE INVENTORY_ITEM_ID = p_key1
1621: AND ORGANIZATION_ID = l_key2;
1622:
1623: -- Since inventory is change, load shippable_item_flag.

Line 1713: FROM MTL_SYSTEM_ITEMS

1709: ,g_item_rec.returnable_flag --5608844
1710: ,g_item_rec.primary_uom_code -- 5608585
1711:
1712:
1713: FROM MTL_SYSTEM_ITEMS
1714: WHERE INVENTORY_ITEM_ID = p_key1
1715: AND ORGANIZATION_ID = p_key2;
1716: -- Pack J catchweight
1717: --Find out whether the inventory org is WMS enabled from mtl_parameters

Line 1791: FROM MTL_SYSTEM_ITEMS

1787: ,g_item_rec.internal_order_enabled_flag
1788: ,g_item_rec.returnable_flag
1789: ,g_item_rec.restrict_subinventories_code
1790:
1791: FROM MTL_SYSTEM_ITEMS
1792: WHERE INVENTORY_ITEM_ID = p_key1
1793: AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1794:
1795: if l_debug_level > 0 then