APPS.INV_ITEM_EVENTS_PVT dependencies on MTL_SYSTEM_ITEMS

Line 53: FROM MTL_SYSTEM_ITEMS_KFV

49: ,x_item_number OUT NOCOPY VARCHAR2) IS
50: BEGIN
51: SELECT CONCATENATED_SEGMENTS, DESCRIPTION
52: INTO x_item_number, x_item_description
53: FROM MTL_SYSTEM_ITEMS_KFV
54: WHERE inventory_item_id = p_inventory_item_id
55: AND organization_id = p_organization_id;
56: END get_Item_Info;
57:

Line 156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086

152:
153: CURSOR c_raise_item_change_event(cp_request_id NUMBER
154: ,cp_xset_id NUMBER) IS
155: SELECT 'x' FROM dual
156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
157: NULL
158: FROM mtl_system_items_interface
159: WHERE set_process_id = cp_xset_id
160: AND process_flag = 7

Line 158: FROM mtl_system_items_interface

154: ,cp_xset_id NUMBER) IS
155: SELECT 'x' FROM dual
156: WHERE EXISTS( SELECT /*+ first_rows index(MTL_SYSTEM_ITEMS_INTERFACE,MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
157: NULL
158: FROM mtl_system_items_interface
159: WHERE set_process_id = cp_xset_id
160: AND process_flag = 7
161: AND request_id = cp_request_id
162: AND transaction_type in ('UPDATE','CREATE'));

Line 582: FROM mtl_system_items_interface

578: CURSOR c_raise_item_change_event(cp_request_id NUMBER
579: ,cp_xset_id NUMBER) IS
580: SELECT 'x' FROM dual
581: WHERE EXISTS( SELECT NULL
582: FROM mtl_system_items_interface
583: WHERE set_process_id = cp_xset_id
584: AND process_flag = 7
585: AND request_id = cp_request_id
586: AND transaction_type in ('UPDATE','CREATE'));

Line 905: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

901: -- ----------------------------------------------------------------------
902:
903: Procedure Invoke_JAI_API (
904: p_action_type IN VARCHAR2
905: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
906: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
907: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
908: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
909: ,p_set_process_id IN NUMBER

Line 906: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

902:
903: Procedure Invoke_JAI_API (
904: p_action_type IN VARCHAR2
905: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
906: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
907: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
908: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
909: ,p_set_process_id IN NUMBER
910: ,p_called_from IN VARCHAR2 ) IS

Line 907: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

903: Procedure Invoke_JAI_API (
904: p_action_type IN VARCHAR2
905: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
906: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
907: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
908: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
909: ,p_set_process_id IN NUMBER
910: ,p_called_from IN VARCHAR2 ) IS
911:

Line 908: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

904: p_action_type IN VARCHAR2
905: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
906: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
907: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
908: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
909: ,p_set_process_id IN NUMBER
910: ,p_called_from IN VARCHAR2 ) IS
911:
912: l_country_code VARCHAR2(4) := NULL;

Line 1004: p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

1000: END Sync_IP_IM_Index;
1001:
1002: --Bug: 4880971
1003: PROCEDURE Invoke_JG_ZZ_API(
1004: p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
1005: ,p_country_code OUT NOCOPY VARCHAR2
1006: ,p_product_code OUT NOCOPY VARCHAR2)
1007: IS
1008: l_jg_zz_object VARCHAR2(1);