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

704: SELECT nvl(lot_status_enabled,'N'), Default_Lot_Status_ID,
705: nvl(serial_status_enabled,'N'), Default_serial_status_ID
706: INTO g_lot_status_enabled, g_default_lot_status_id,
707: g_serial_status_enabled, g_default_serial_status_id
708: FROM MTL_SYSTEM_ITEMS
709: WHERE organization_id = p_organization_id
710: AND inventory_item_id = p_inventory_item_id;
711: --bug3713809
712: g_organization_id := p_organization_id;

Line 868: FROM mtl_system_items msi,

864: BEGIN
865: IF p_inventory_item_id <> NVL(g_old_item_id,-9999) THEN
866: SELECT NVL(msi.comms_nl_trackable_flag,'N')
867: INTO g_item_trackable
868: FROM mtl_system_items msi,
869: mtl_parameters mp
870: WHERE msi.inventory_item_id = p_inventory_item_id
871: AND msi.enabled_flag = 'Y'
872: AND nvl (msi.start_date_active, sysdate) <= sysdate

Line 1700: from mtl_system_items

1696: when NO_DATA_FOUND then
1697:
1698: select default_lot_status_id
1699: into g_isa_lot_number_status_id
1700: from mtl_system_items
1701: where organization_id = p_organization_id
1702: and inventory_item_id = p_inventory_item_id;
1703:
1704: l_status_id := g_isa_lot_number_status_id;

Line 1944: FROM mtl_system_items

1940: inv_trx_util_pub.TRACE('In dynamic serial checking default serial status'
1941: || l_status_id, 'INV_MATERIAL_STATUS_GRP', 14);
1942: SELECT default_serial_status_id
1943: INTO l_status_id
1944: FROM mtl_system_items
1945: WHERE inventory_item_id = p_inventory_item_id
1946: AND organization_id = p_organization_id;
1947:
1948: END;

Line 2114: FROM mtl_system_items

2110:
2111:
2112: SELECT restrict_locators_code
2113: INTO l_restrict_loc_code
2114: FROM mtl_system_items
2115: WHERE organization_id = p_org_id
2116: AND inventory_item_id = p_inventory_item_id;
2117:
2118: IF (l_restrict_loc_code = 2) THEN

Line 2155: FROM mtl_system_items

2151: BEGIN
2152:
2153: SELECT restrict_subinventories_code
2154: INTO l_restrict_sub_code
2155: FROM mtl_system_items
2156: WHERE organization_id = p_org_id
2157: AND inventory_item_id = p_inventory_item_id;
2158:
2159: IF (l_restrict_sub_code = 2) THEN

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

2701: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2702: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2703: P.STOCK_LOCATOR_CONTROL_CODE))
2704: INTO l_loc_control
2705: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2706: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2707: AND I.ORGANIZATION_ID = p_org_id
2708: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2709: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID

Line 4241: FROM mtl_system_items

4237: -- to get sub and loc restrict code ,if not passed
4238: IF p_restrict_sub_code IS NULL OR p_restrict_loc_code IS NULL THEN
4239: SELECT restrict_subinventories_code,restrict_locators_code
4240: INTO l_restrict_sub_code,l_restrict_loc_code
4241: FROM mtl_system_items
4242: WHERE organization_id = p_org_id
4243: AND inventory_item_id = p_inventory_item_id;
4244: ELSE
4245: l_restrict_loc_code := p_restrict_loc_code;