APPS.INV_EGO_REVISION_VALIDATE dependencies on MTL_PARAMETERS

Line 345: FROM mtl_parameters

341: WHERE inventory_item_id = P_Item_Id
342: /*Changed for FP bug 8213894 with base bug 7492587*/
343: /* AND organization_id IN
344: (SELECT organization_id
345: FROM mtl_parameters
346: WHERE organization_id = master_organization_id); */
347: AND organization_id = P_Org_Id;
348:
349: --In update mode if item is unapproved donot validate "Pending" status

Line 541: FROM mtl_parameters

537: FROM mtl_system_items_b
538: WHERE inventory_item_id = cp_item_id
539: AND organization_id IN
540: (SELECT organization_id
541: FROM mtl_parameters
542: WHERE organization_id = master_organization_id)
543: UNION
544: SELECT Lifecycle_id, Current_Phase_Id
545: FROM mtl_system_items_interface

Line 550: FROM mtl_parameters

546: WHERE inventory_item_id = cp_item_id
547: AND process_flag = 4
548: AND organization_id IN
549: (SELECT organization_id
550: FROM mtl_parameters
551: WHERE organization_id = master_organization_id);
552:
553: CURSOR c_get_control_level IS
554: SELECT control_level

Line 691: FROM mtl_parameters mp

687: AND int.set_process_id = P_Set_id
688: AND int.process_flag = P_Process_Flag
689: AND EXISTS -- organization_id IN
690: (SELECT 1 --organization_id
691: FROM mtl_parameters mp
692: WHERE int.organization_id = mp.master_organization_id
693: AND mp.organization_id = mp.master_organization_id )
694: FOR UPDATE OF int.current_phase_id, int.process_flag;
695:

Line 719: FROM mtl_parameters mp

715: AND int.set_process_id = P_Set_id
716: AND int.process_flag = P_Process_Flag
717: AND NOT EXISTS -- organization_id NOT IN
718: (SELECT 1 -- organization_id
719: FROM mtl_parameters mp
720: WHERE int.organization_id = mp.master_organization_id
721: AND mp.organization_id = mp.master_organization_id)
722: FOR UPDATE OF int.current_phase_id,int.process_flag;
723:

Line 1817: mtl_parameters mp

1813: msii.item_number, --5522789
1814: mp.master_organization_id,
1815: msii.created_by
1816: FROM mtl_system_items_interface msii,
1817: mtl_parameters mp
1818: WHERE (msii.organization_id = P_Org_Id OR P_All_Org = 1)
1819: AND msii.set_process_id = P_Set_id
1820: AND msii.process_flag = P_Process_flag
1821: AND msii.organization_id = mp.organization_id--Bug 5238510

Line 2995: mtl_parameters mp

2991: IS
2992: SELECT interface.inventory_item_id, interface.organization_id,
2993: interface.item_catalog_group_id
2994: FROM mtl_system_items_interface interface,
2995: mtl_parameters mp
2996: WHERE interface.SET_PROCESS_ID = p_set_process_id
2997: AND interface.PROCESS_FLAG = 4
2998: AND interface.TRANSACTION_TYPE = 'CREATE'
2999: AND interface.ITEM_CATALOG_GROUP_ID IS NOT NULL

Line 3072: mtl_parameters mp

3068: Get_Initial_Lifecycle_Phase(lifecycle_id))
3069: WHERE (inventory_item_id, organization_id) IN
3070: (SELECT interface.inventory_item_id, interface.organization_id
3071: FROM mtl_system_items_interface interface,
3072: mtl_parameters mp
3073: WHERE interface.set_process_id = p_set_process_id
3074: AND interface.process_flag = 4
3075: AND interface.transaction_type = 'CREATE'
3076: AND interface.item_catalog_group_id IS NOT NULL

Line 3123: MTL_PARAMETERS mp

3119: WHERE msii.ROWID IN
3120: ( SELECT interface.ROWID
3121: FROM mtl_system_items_interface interface,
3122: -- MTL_ITEM_CATALOG_GROUPS_B micb,
3123: MTL_PARAMETERS mp
3124: WHERE interface.SET_PROCESS_ID = p_set_process_id
3125: AND interface.PROCESS_FLAG = 4
3126: AND interface.TRANSACTION_TYPE = 'CREATE'
3127: --AND interface.ITEM_CATALOG_GROUP_ID = micb.item_catalog_group_id

Line 3199: MTL_PARAMETERS mp

3195: micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
3196: mp.ORGANIZATION_CODE
3197: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,
3198: MTL_ITEM_CATALOG_GROUPS_B micb,
3199: MTL_PARAMETERS mp
3200: WHERE interface.SET_PROCESS_ID = cp_set_process_id
3201: AND interface.PROCESS_FLAG = 4
3202: AND interface.TRANSACTION_TYPE = 'CREATE'
3203: AND interface.ITEM_CATALOG_GROUP_ID = micb.ITEM_CATALOG_GROUP_ID

Line 3813: FROM mtl_parameters

3809: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3810: BEGIN
3811:
3812: SELECT organization_code INTO l_org_code
3813: FROM mtl_parameters
3814: WHERE organization_id = p_organization_id;
3815:
3816: SELECT new_item_req_change_type_id INTO l_type_id
3817: FROM mtl_item_catalog_groups_b

Line 4015: FROM mtl_parameters

4011:
4012: CURSOR c_master_org (cp_organization_id IN NUMBER)
4013: IS
4014: SELECT master_organization_id
4015: FROM mtl_parameters
4016: WHERE organization_id = cp_organization_id;
4017:
4018: CURSOR c_get_existing_item_details (Cp_inventory_item_id IN NUMBER,
4019: Cp_organization_id IN NUMBER)