APPS.INV_TXN_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS

Line 58: FROM MTL_SYSTEM_ITEMS_KFV

54: restrict_locators_code,
55: location_control_code,
56: restrict_subinventories_code
57: INTO l_Item_Info
58: FROM MTL_SYSTEM_ITEMS_KFV
59: WHERE concatenated_segments = p_Concatenated_Segments and
60: organization_id = p_Organization_Id and
61: mtl_transactions_enabled_flag = 'Y';
62:

Line 1432: FROM mtl_system_items

1428: WHERE transaction_temp_id = p_transaction_temp_id;
1429:
1430: CURSOR c_item IS
1431: SELECT primary_uom_code
1432: FROM mtl_system_items
1433: WHERE inventory_item_id = p_inventory_item_id
1434: AND organization_id = p_organization_id;
1435:
1436: CURSOR c_moq(x_cost_group_id number) IS

Line 2420: FROM mtl_system_items

2416: lot_control_code
2417: INTO l_revison_control_code,
2418: l_serial_number_control_code,
2419: l_lot_control_code
2420: FROM mtl_system_items
2421: WHERE inventory_item_id = l_item_id
2422: AND organization_id = p_organization_id;
2423:
2424: l_is_revision_control := FALSE;

Line 2659: FROM mtl_system_items

2655: lot_control_code
2656: INTO l_revison_control_code,
2657: l_serial_number_control_code,
2658: l_lot_control_code
2659: FROM mtl_system_items
2660: WHERE inventory_item_id = l_item_id
2661: AND organization_id = p_organization_id;
2662:
2663: l_is_revision_control := FALSE;

Line 3437: FROM mtl_system_items

3433: IF p_transaction_action_id IN (3, 21) THEN
3434: l_org := p_to_organization_id;
3435: SELECT restrict_locators_code
3436: INTO l_restrict_locators_code
3437: FROM mtl_system_items
3438: WHERE inventory_item_id = p_inventory_item_id
3439: AND organization_id = l_org;
3440: ELSE
3441: l_org := p_organization_id;

Line 3503: FROM mtl_system_items

3499: l_org := p_to_organization_id;
3500:
3501: SELECT restrict_locators_code
3502: INTO l_restrict_locators_code
3503: FROM mtl_system_items
3504: WHERE inventory_item_id = p_inventory_item_id
3505: AND organization_id = l_org;
3506: ELSE
3507: l_org := p_organization_id;

Line 4136: FROM mtl_system_items

4132: WHERE transaction_temp_id = p_transaction_temp_id;
4133:
4134: CURSOR c_item IS
4135: SELECT primary_uom_code
4136: FROM mtl_system_items
4137: WHERE inventory_item_id = p_inventory_item_id
4138: AND organization_id = p_organization_id;
4139:
4140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);