APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SYSTEM_ITEMS

Line 36: g_item_trackable mtl_system_items.comms_nl_trackable_flag%TYPE;

32: --Bug #5367711
33: --Cache the variables for old item, item trackable and freeze flag
34: g_old_item_id NUMBER;
35: g_freeze_flag csi_install_parameters.freeze_flag%TYPE;
36: g_item_trackable mtl_system_items.comms_nl_trackable_flag%TYPE;
37: g_transaction_action_id NUMBER;
38: g_transaction_source_type_id NUMBER;
39:
40: -- Onhand Material Status Support

Line 694: FROM MTL_SYSTEM_ITEMS

690: SELECT nvl(lot_status_enabled,'N'), Default_Lot_Status_ID,
691: nvl(serial_status_enabled,'N'), Default_serial_status_ID
692: INTO g_lot_status_enabled, g_default_lot_status_id,
693: g_serial_status_enabled, g_default_serial_status_id
694: FROM MTL_SYSTEM_ITEMS
695: WHERE organization_id = p_organization_id
696: AND inventory_item_id = p_inventory_item_id;
697: --bug3713809
698: g_organization_id := p_organization_id;

Line 846: FROM mtl_system_items msi,

842: BEGIN
843: IF p_inventory_item_id <> NVL(g_old_item_id,-9999) THEN
844: SELECT NVL(msi.comms_nl_trackable_flag,'N')
845: INTO g_item_trackable
846: FROM mtl_system_items msi,
847: mtl_parameters mp
848: WHERE msi.inventory_item_id = p_inventory_item_id
849: AND msi.enabled_flag = 'Y'
850: AND nvl (msi.start_date_active, sysdate) <= sysdate

Line 1726: FROM mtl_system_items

1722:
1723:
1724: SELECT restrict_locators_code
1725: INTO l_restrict_loc_code
1726: FROM mtl_system_items
1727: WHERE organization_id = p_org_id
1728: AND inventory_item_id = p_inventory_item_id;
1729:
1730: IF (l_restrict_loc_code = 2) THEN

Line 1767: FROM mtl_system_items

1763: BEGIN
1764:
1765: SELECT restrict_subinventories_code
1766: INTO l_restrict_sub_code
1767: FROM mtl_system_items
1768: WHERE organization_id = p_org_id
1769: AND inventory_item_id = p_inventory_item_id;
1770:
1771: IF (l_restrict_sub_code = 2) THEN

Line 2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

2195: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2196: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2197: P.STOCK_LOCATOR_CONTROL_CODE))
2198: INTO l_loc_control
2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2200: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2201: AND I.ORGANIZATION_ID = p_org_id
2202: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2203: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID