[Home] [Help]
358: FROM mtl_system_items_b
359: WHERE inventory_item_id = P_Item_Id
360: AND organization_id IN
361: (SELECT organization_id
362: FROM mtl_parameters
363: WHERE organization_id = master_organization_id);
364:
365: --In update mode if item is unapproved donot validate "Pending" status
366: Cursor c_check_item_phase_status
548: FROM mtl_system_items_b
549: WHERE inventory_item_id = cp_item_id
550: AND organization_id IN
551: (SELECT organization_id
552: FROM mtl_parameters
553: WHERE organization_id = master_organization_id)
554: UNION
555: SELECT Lifecycle_id, Current_Phase_Id
556: FROM mtl_system_items_interface
557: WHERE inventory_item_id = cp_item_id
558: AND process_flag = 4
559: AND organization_id IN
560: (SELECT organization_id
561: FROM mtl_parameters
562: WHERE organization_id = master_organization_id);
563:
564: CURSOR c_get_control_level IS
565: SELECT control_level
698: AND int.set_process_id = P_Set_id
699: AND int.process_flag = P_Process_Flag
700: AND EXISTS -- organization_id IN
701: (SELECT 1 --organization_id
702: FROM mtl_parameters mp
703: WHERE int.organization_id = mp.master_organization_id
704: AND mp.organization_id = mp.master_organization_id )
705: FOR UPDATE OF int.current_phase_id, int.process_flag;
706:
726: AND int.set_process_id = P_Set_id
727: AND int.process_flag = P_Process_Flag
728: AND NOT EXISTS -- organization_id NOT IN
729: (SELECT 1 -- organization_id
730: FROM mtl_parameters mp
731: WHERE int.organization_id = mp.master_organization_id
732: AND mp.organization_id = mp.master_organization_id)
733: FOR UPDATE OF int.current_phase_id,int.process_flag;
734:
1715: msii.item_number, --5522789
1716: mp.master_organization_id,
1717: msii.created_by
1718: FROM mtl_system_items_interface msii,
1719: mtl_parameters mp
1720: WHERE (msii.organization_id = P_Org_Id OR P_All_Org = 1)
1721: AND msii.set_process_id = P_Set_id
1722: AND msii.process_flag = P_Process_flag
1723: AND msii.organization_id = mp.organization_id--Bug 5238510
2820: IS
2821: SELECT interface.inventory_item_id, interface.organization_id,
2822: interface.item_catalog_group_id
2823: FROM mtl_system_items_interface interface,
2824: mtl_parameters mp
2825: WHERE interface.SET_PROCESS_ID = p_set_process_id
2826: AND interface.PROCESS_FLAG = 4
2827: AND interface.TRANSACTION_TYPE = 'CREATE'
2828: AND interface.ITEM_CATALOG_GROUP_ID IS NOT NULL
2909: WHERE msii.ROWID IN
2910: ( SELECT interface.ROWID
2911: FROM mtl_system_items_interface interface,
2912: -- MTL_ITEM_CATALOG_GROUPS_B micb,
2913: MTL_PARAMETERS mp
2914: WHERE interface.SET_PROCESS_ID = p_set_process_id
2915: AND interface.PROCESS_FLAG = 4
2916: AND interface.TRANSACTION_TYPE = 'CREATE'
2917: --AND interface.ITEM_CATALOG_GROUP_ID = micb.item_catalog_group_id
2985: micb.NEW_ITEM_REQ_CHANGE_TYPE_ID,
2986: mp.ORGANIZATION_CODE
2987: FROM MTL_SYSTEM_ITEMS_INTERFACE interface,
2988: MTL_ITEM_CATALOG_GROUPS_B micb,
2989: MTL_PARAMETERS mp
2990: WHERE interface.SET_PROCESS_ID = cp_set_process_id
2991: AND interface.PROCESS_FLAG = 4
2992: AND interface.TRANSACTION_TYPE = 'CREATE'
2993: AND interface.ITEM_CATALOG_GROUP_ID = micb.ITEM_CATALOG_GROUP_ID
3588: l_return_status VARCHAR2(10) := FND_API.G_RET_STS_SUCCESS;
3589: BEGIN
3590:
3591: SELECT organization_code INTO l_org_code
3592: FROM mtl_parameters
3593: WHERE organization_id = p_organization_id;
3594:
3595: SELECT new_item_req_change_type_id INTO l_type_id
3596: FROM mtl_item_catalog_groups_b
3751:
3752: CURSOR c_master_org (cp_organization_id IN NUMBER)
3753: IS
3754: SELECT master_organization_id
3755: FROM mtl_parameters
3756: WHERE organization_id = cp_organization_id;
3757:
3758: CURSOR c_get_existing_item_details (Cp_inventory_item_id IN NUMBER,
3759: Cp_organization_id IN NUMBER)