APPS.INV_TXN_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS

Line 55: FROM MTL_SYSTEM_ITEMS_KFV

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

Line 1585: FROM mtl_system_items

1581: WHERE transaction_temp_id = p_transaction_temp_id;
1582:
1583: CURSOR c_item IS
1584: SELECT primary_uom_code
1585: FROM mtl_system_items
1586: WHERE inventory_item_id = p_inventory_item_id
1587: AND organization_id = p_organization_id;
1588:
1589: CURSOR c_moq(x_cost_group_id number) IS

Line 2674: FROM mtl_system_items

2670: lot_control_code
2671: INTO l_revison_control_code,
2672: l_serial_number_control_code,
2673: l_lot_control_code
2674: FROM mtl_system_items
2675: WHERE inventory_item_id = l_item_id
2676: AND organization_id = p_organization_id;
2677:
2678: l_is_revision_control := FALSE;

Line 2919: FROM mtl_system_items

2915: lot_control_code
2916: INTO l_revison_control_code,
2917: l_serial_number_control_code,
2918: l_lot_control_code
2919: FROM mtl_system_items
2920: WHERE inventory_item_id = l_item_id
2921: AND organization_id = p_organization_id;
2922:
2923: l_is_revision_control := FALSE;

Line 3716: FROM mtl_system_items

3712: IF p_transaction_action_id IN (3, 21) THEN
3713: l_org := p_to_organization_id;
3714: SELECT restrict_locators_code
3715: INTO l_restrict_locators_code
3716: FROM mtl_system_items
3717: WHERE inventory_item_id = p_inventory_item_id
3718: AND organization_id = l_org;
3719: ELSE
3720: l_org := p_organization_id;

Line 3782: FROM mtl_system_items

3778: l_org := p_to_organization_id;
3779:
3780: SELECT restrict_locators_code
3781: INTO l_restrict_locators_code
3782: FROM mtl_system_items
3783: WHERE inventory_item_id = p_inventory_item_id
3784: AND organization_id = l_org;
3785: ELSE
3786: l_org := p_organization_id;

Line 4415: FROM mtl_system_items

4411: WHERE transaction_temp_id = p_transaction_temp_id;
4412:
4413: CURSOR c_item IS
4414: SELECT primary_uom_code
4415: FROM mtl_system_items
4416: WHERE inventory_item_id = p_inventory_item_id
4417: AND organization_id = p_organization_id;
4418:
4419: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);