APPS.GMD_COA_DATA_OM_NEW dependencies on OE_ORDER_LINES_ALL

Line 1480: oe_order_lines_all l,

1476: pr.party_name cust_name ,
1477: 0 alloc_qty
1478: FROM
1479: oe_order_headers_all h,
1480: oe_order_lines_all l,
1481: wsh_delivery_details wdd,
1482: wsh_new_deliveries wnd,
1483: wsh_delivery_assignments wda,
1484: mtl_parameters ship_from_org,

Line 1544: oe_order_lines_all l,

1540: 0 alloc_qty
1541:
1542: FROM
1543: oe_order_headers_all h,
1544: oe_order_lines_all l,
1545: mtl_parameters ship_from_org,
1546: mtl_system_items_b_kfv msi, --INVCONV
1547: hz_cust_accounts c,
1548: hz_cust_site_uses_all s,

Line 1596: CURSOR get_lot_tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS

1592:
1593: --INVCONV
1594: --RLNAGARA Bug # 4916856
1595: -- Bug# 5629675 Added distinct in the first select and added union.
1596: CURSOR get_lot_tran(p_order_line_id oe_order_lines_all.line_id%TYPE) IS
1597: SELECT distinct MTLT.LOT_NUMBER
1598: FROM MTL_TRANSACTION_LOTS_TEMP MTLT,
1599: MTL_MATERIAL_TRANSACTIONS_TEMP MMTT,
1600: MTL_TXN_REQUEST_LINES_V MTRL