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.GMI_OM_ALLOC_API_PUB dependencies on IC_ITEM_MST_B

Line 110: l_ic_item_mst_rec ic_item_mst_b%ROWTYPE;

106: l_apps_um VARCHAR2(3);
107: l_order_um2 VARCHAR2(3);
108: l_loc_inactive NUMBER;
109: l_ship_from_org_id NUMBER;
110: l_ic_item_mst_rec ic_item_mst_b%ROWTYPE;
111: l_ic_whse_mst_rec ic_whse_mst%ROWTYPE;
112: l_ic_lots_mst_rec ic_lots_mst%ROWTYPE;
113: l_message VARCHAR2(1000);
114: i NUMBER;

Line 1900: , x_ic_item_mst_rec OUT NOCOPY IC_ITEM_MST_B%ROWTYPE

1896:
1897: PROCEDURE Get_Item_Details
1898: ( p_organization_id IN NUMBER
1899: , p_inventory_item_id IN NUMBER
1900: , x_ic_item_mst_rec OUT NOCOPY IC_ITEM_MST_B%ROWTYPE
1901: , x_return_status OUT NOCOPY VARCHAR2
1902: , x_msg_count OUT NOCOPY NUMBER
1903: , x_msg_data OUT NOCOPY VARCHAR2
1904: ) IS

Line 1911: FROM ic_item_mst_b ic

1907:
1908: CURSOR ic_item_mst_cur ( discrete_org_id IN NUMBER
1909: , discrete_item_id IN NUMBER) IS
1910: SELECT ic.*
1911: FROM ic_item_mst_b ic
1912: , mtl_system_items mtl
1913: WHERE delete_mark = 0
1914: AND ic.item_no = mtl.segment1
1915: AND mtl.organization_id = discrete_org_id