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 33: line_id oe_order_lines.line_id%TYPE,

29:
30: TYPE t_coa_hdr_rec IS RECORD
31: (gmd_coa_id BINARY_INTEGER,
32: order_id oe_order_headers.header_id%TYPE,
33: line_id oe_order_lines.line_id%TYPE,
34: delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
35: orgn_code op_ordr_hdr.orgn_code%TYPE,
36: order_no oe_order_headers.order_number%TYPE,
37: custpo_no oe_order_headers.cust_po_number%TYPE,

Line 38: shipdate oe_order_lines.schedule_ship_date%TYPE,

34: delivery_detail_id wsh_delivery_details.delivery_detail_id%TYPE,
35: orgn_code op_ordr_hdr.orgn_code%TYPE,
36: order_no oe_order_headers.order_number%TYPE,
37: custpo_no oe_order_headers.cust_po_number%TYPE,
38: shipdate oe_order_lines.schedule_ship_date%TYPE,
39: cust_id hz_cust_accounts.cust_account_id%TYPE,
40: cust_no hz_cust_accounts.account_number%TYPE,
41: cust_name hz_parties.party_name%TYPE,
42: bol_id wsh_new_deliveries.delivery_id%TYPE,

Line 53: order_qty1 oe_order_lines.ordered_quantity%TYPE,

49: lot_id ic_lots_mst.lot_id%TYPE,
50: lot_no ic_lots_mst.lot_no%TYPE,
51: lot_desc ic_lots_mst.lot_desc%TYPE,
52: sublot_no ic_lots_mst.sublot_no%TYPE,
53: order_qty1 oe_order_lines.ordered_quantity%TYPE,
54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,

Line 54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,

50: lot_no ic_lots_mst.lot_no%TYPE,
51: lot_desc ic_lots_mst.lot_desc%TYPE,
52: sublot_no ic_lots_mst.sublot_no%TYPE,
53: order_qty1 oe_order_lines.ordered_quantity%TYPE,
54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,

Line 55: order_um1 oe_order_lines.order_quantity_uom%TYPE,

51: lot_desc ic_lots_mst.lot_desc%TYPE,
52: sublot_no ic_lots_mst.sublot_no%TYPE,
53: order_qty1 oe_order_lines.ordered_quantity%TYPE,
54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,

Line 56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,

52: sublot_no ic_lots_mst.sublot_no%TYPE,
53: order_qty1 oe_order_lines.ordered_quantity%TYPE,
54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,
60: org_id oe_order_lines.org_id%TYPE,

Line 57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,

53: order_qty1 oe_order_lines.ordered_quantity%TYPE,
54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,
60: org_id oe_order_lines.org_id%TYPE,
61: report_title VARCHAR2(4)

Line 58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,

54: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,
60: org_id oe_order_lines.org_id%TYPE,
61: report_title VARCHAR2(4)
62: );

Line 59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,

55: order_um1 oe_order_lines.order_quantity_uom%TYPE,
56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,
60: org_id oe_order_lines.org_id%TYPE,
61: report_title VARCHAR2(4)
62: );
63:

Line 60: org_id oe_order_lines.org_id%TYPE,

56: order_um2 oe_order_lines.ordered_quantity_UOM2%TYPE,
57: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
58: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
59: ship_from_org_id oe_order_lines.ship_to_org_id%TYPE,
60: org_id oe_order_lines.org_id%TYPE,
61: report_title VARCHAR2(4)
62: );
63:
64: TYPE t_coa_dtl_rec IS RECORD