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.GMD_COA_DATA_OM_NEW dependencies on OE_ORDER_LINES_ALL

Line 1572: oe_order_lines_all l,

1568: pr.party_name cust_name ,
1569: 0 alloc_qty
1570: FROM
1571: oe_order_headers_all h,
1572: oe_order_lines_all l,
1573: wsh_delivery_details wdd,
1574: wsh_new_deliveries wnd,
1575: wsh_delivery_assignments wda,
1576: mtl_parameters ship_from_org,

Line 1655: oe_order_lines_all l,

1651: pr.party_name cust_name ,
1652: 0 alloc_qty
1653: FROM
1654: oe_order_headers_all h,
1655: oe_order_lines_all l,
1656: wsh_delivery_details wdd,
1657: wsh_new_deliveries wnd,
1658: wsh_delivery_assignments wda,
1659: mtl_parameters ship_from_org,

Line 1720: oe_order_lines_all l,

1716: 0 alloc_qty
1717:
1718: FROM
1719: oe_order_headers_all h,
1720: oe_order_lines_all l,
1721: mtl_parameters ship_from_org,
1722: mtl_system_items_b_kfv msi, --INVCONV
1723: hz_cust_accounts c,
1724: hz_cust_site_uses_all s,

Line 1772: CURSOR Get_Lot_Tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS

1768:
1769: --INVCONV
1770: --RLNAGARA Bug # 4916856
1771: -- Bug# 5629675 Added distinct in the first select and added union.
1772: CURSOR Get_Lot_Tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS
1773: SELECT distinct MTLT.LOT_NUMBER, Abs(mtlt.primary_quantity) qty1 -- 12659784 added primary_quantity
1774: FROM MTL_TRANSACTION_LOTS_TEMP MTLT,
1775: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
1776: MTL_TXN_REQUEST_LINES_V MTRL