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 1621: FROM MTL_SYSTEM_ITEMS

1617: ,g_item_rec.lot_divisible_flag
1618: ,g_item_rec.grade_control_flag
1619: ,g_item_rec.lot_control_code
1620: ,g_item_rec.CONTRACT_ITEM_TYPE_CODE --sol_ord_er #16014165
1621: FROM MTL_SYSTEM_ITEMS
1622: WHERE INVENTORY_ITEM_ID = p_key1
1623: AND ORGANIZATION_ID = l_key2;
1624:
1625: -- Since inventory is change, load shippable_item_flag.

Line 1715: FROM MTL_SYSTEM_ITEMS

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

Line 1793: FROM MTL_SYSTEM_ITEMS

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