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.JAI_OM_WDD_TRIGGER_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 204: JAI_INV_SUBINV_DTLS

200: SELECT
201: NVL(Location_id,0),
202: trading
203: FROM
204: JAI_INV_SUBINV_DTLS
205: WHERE
206: Sub_Inventory_Name = v_subinventory AND
207: organization_id = v_organization_id ;
208:

Line 1272: FROM JAI_INV_SUBINV_DTLS

1268: WHERE Delivery_Detail_Id = v_delivery_detail_id;
1269: CURSOR Location_Cursor IS
1270: SELECT NVL(Location_id,0),
1271: trading
1272: FROM JAI_INV_SUBINV_DTLS
1273: WHERE Sub_Inventory_Name = v_subinventory
1274: AND organization_id = v_organization_id;
1275: CURSOR get_ship_to_org_id_cur( p_line_id NUMBER) IS
1276: SELECT ship_to_org_id

Line 1380: FROM JAI_INV_SUBINV_DTLS A

1376: inventory_item_id = p_item_id;
1377:
1378: CURSOR bonded_cur(p_organization_id NUMBER, p_subinventory VARCHAR2) IS
1379: SELECT NVL(A.bonded,'Y') bonded
1380: FROM JAI_INV_SUBINV_DTLS A
1381: WHERE A.sub_inventory_name = p_subinventory
1382: AND A.organization_id = p_organization_id;
1383: CURSOR register_code_cur(p_organization_id NUMBER, p_location_id NUMBER, p_order_type_id NUMBER) IS
1384: SELECT A.register_code