eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: FROM mtl_system_items_interface

152: CURSOR c_raise_item_change_event(cp_request_id NUMBER
153: ,cp_xset_id NUMBER) IS
154: SELECT 'x' FROM dual
155: WHERE EXISTS( SELECT NULL
156: FROM mtl_system_items_interface
157: WHERE set_process_id = cp_xset_id
158: AND process_flag = 7
159: AND request_id = cp_request_id
160: AND transaction_type in ('UPDATE','CREATE'));

Line 578: FROM mtl_system_items_interface

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

Line 901: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

897: -- ----------------------------------------------------------------------
898:
899: Procedure Invoke_JAI_API (
900: p_action_type IN VARCHAR2
901: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
902: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
903: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
904: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
905: ,p_set_process_id IN NUMBER

Line 902: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

898:
899: Procedure Invoke_JAI_API (
900: p_action_type IN VARCHAR2
901: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
902: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
903: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
904: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
905: ,p_set_process_id IN NUMBER
906: ,p_called_from IN VARCHAR2 ) IS

Line 903: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

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

Line 904: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE

900: p_action_type IN VARCHAR2
901: ,p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
902: ,p_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
903: ,p_source_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
904: ,p_source_inventory_item_id IN MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID%TYPE
905: ,p_set_process_id IN NUMBER
906: ,p_called_from IN VARCHAR2 ) IS
907:
908: l_country_code VARCHAR2(4) := NULL;

Line 998: p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE

994: END Sync_IP_IM_Index;
995:
996: --Bug: 4880971
997: PROCEDURE Invoke_JG_ZZ_API(
998: p_organization_id IN MTL_SYSTEM_ITEMS.ORGANIZATION_ID%TYPE
999: ,p_country_code OUT NOCOPY VARCHAR2
1000: ,p_product_code OUT NOCOPY VARCHAR2)
1001: IS
1002: l_jg_zz_object VARCHAR2(1);