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 dependencies on OE_ORDER_LINES

Line 834: oe_order_lines_all l,

830: pr.party_name cust_name ,
831: 0 alloc_qty
832: FROM
833: oe_order_headers_all h,
834: oe_order_lines_all l,
835: wsh_delivery_details wdd,
836: wsh_new_deliveries wnd,
837: wsh_delivery_assignments wda,
838: mtl_parameters ship_from_org,

Line 949: /* CURSOR get_cust_info (c_ship_to_org_id OE_ORDER_LINES.SHIP_TO_ORG_ID%TYPE) IS

945: from op_cust_mst
946: WHERE cust_id = c_cust_id
947: AND delete_mark= 0; */
948:
949: /* CURSOR get_cust_info (c_ship_to_org_id OE_ORDER_LINES.SHIP_TO_ORG_ID%TYPE) IS
950: SELECT
951: A.CUST_ACCT_SITE_ID cust_id,
952: C.ACCOUNT_NUMBER cust_no,
953: PR.PARTY_NAME cust_name

Line 976: CURSOR get_whse_info (c_ship_from_org_id oe_order_lines.ship_from_org_id%TYPE) IS

972: WHERE
973: whse_code = c_whse_code
974: and delete_mark = 0
975: ;*/
976: CURSOR get_whse_info (c_ship_from_org_id oe_order_lines.ship_from_org_id%TYPE) IS
977: SELECT s.orgn_code,
978: w.whse_code,
979: w.whse_name
980: FROM mtl_parameters p,