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_HEADERS

Line 13: order_id oe_order_headers.header_id%TYPE,

9: g_gmdlog_location VARCHAR2(255) := NULL;
10:
11: TYPE t_coa_hdr_rec IS RECORD
12: (gmd_coa_id BINARY_INTEGER,
13: order_id oe_order_headers.header_id%TYPE,
14: line_id oe_order_lines.line_id%TYPE,
15: delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
16: --orgn_code op_ordr_hdr.orgn_code%TYPE, --INVCONV
17: organization_id mtl_parameters.organization_id%TYPE, --INVCONV

Line 19: order_no oe_order_headers.order_number%TYPE,

15: delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
16: --orgn_code op_ordr_hdr.orgn_code%TYPE, --INVCONV
17: organization_id mtl_parameters.organization_id%TYPE, --INVCONV
18: organization_code mtl_parameters.organization_code%TYPE, --INVCONV
19: order_no oe_order_headers.order_number%TYPE,
20: custpo_no oe_order_headers.cust_po_number%TYPE,
21: shipdate oe_order_lines.schedule_ship_date%TYPE,
22: cust_id hz_cust_accounts.cust_account_id%TYPE,
23: cust_no hz_cust_accounts.account_number%TYPE,

Line 20: custpo_no oe_order_headers.cust_po_number%TYPE,

16: --orgn_code op_ordr_hdr.orgn_code%TYPE, --INVCONV
17: organization_id mtl_parameters.organization_id%TYPE, --INVCONV
18: organization_code mtl_parameters.organization_code%TYPE, --INVCONV
19: order_no oe_order_headers.order_number%TYPE,
20: custpo_no oe_order_headers.cust_po_number%TYPE,
21: shipdate oe_order_lines.schedule_ship_date%TYPE,
22: cust_id hz_cust_accounts.cust_account_id%TYPE,
23: cust_no hz_cust_accounts.account_number%TYPE,
24: cust_name hz_parties.party_name%TYPE,

Line 84: (order_id oe_order_headers_all.header_id%TYPE,

80: coa_sort_order NUMBER
81: );
82:
83: TYPE t_coa_parameters IS RECORD
84: (order_id oe_order_headers_all.header_id%TYPE,
85: --orgn_code sy_orgn_mst.orgn_code%TYPE, --INVCONV
86: organization_id mtl_parameters.organization_id%TYPE, --INVCONV
87: cust_id hz_cust_accounts.cust_account_id%TYPE,
88: delivery_id wsh_new_deliveries.delivery_id%TYPE,

Line 98: org_id oe_order_headers_all.org_id%TYPE,

94: locator_id NUMBER, --INVCONV
95: --lot_id ic_lots_mst.lot_id%TYPE, --INVCONV
96: --lot_no ic_lots_mst.lot_no%TYPE, --INVCONV
97: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
98: org_id oe_order_headers_all.org_id%TYPE,
99: sampling_event_id gmd_sampling_events.sampling_event_id%TYPE,
100: spec_id gmd_specifications_b.spec_id%TYPE,
101: ship_to_site_id hz_cust_site_uses_all.site_use_id%TYPE -- Bug# 5399406
102: );