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

Line 14: line_id oe_order_lines.line_id%TYPE,

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
18: organization_code mtl_parameters.organization_code%TYPE, --INVCONV

Line 21: shipdate oe_order_lines.schedule_ship_date%TYPE,

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,
25: bol_id wsh_new_deliveries.delivery_id%TYPE,

Line 43: order_qty1 oe_order_lines.ordered_quantity%TYPE,

39: --lot_desc ic_lots_mst.lot_desc%TYPE, --INVCONV
40: --sublot_no ic_lots_mst.sublot_no%TYPE, --INVCONV
41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,

Line 44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,

40: --sublot_no ic_lots_mst.sublot_no%TYPE, --INVCONV
41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,

Line 45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV

41: lot_number mtl_lot_numbers.lot_number%TYPE, --INVCONV
42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2

Line 46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV

42: lot_description mtl_lot_numbers.description%TYPE, --INVCONV
43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV

Line 47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,

43: order_qty1 oe_order_lines.ordered_quantity%TYPE,
44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,

Line 48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,

44: order_qty2 oe_order_lines.ordered_quantity2%TYPE,
45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.

Line 49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2

45: order_uom1 oe_order_lines.order_quantity_uom%TYPE, --INVCONV
46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.
53: org_id oe_order_lines.org_id%TYPE,

Line 50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV

46: order_uom2 oe_order_lines.ordered_quantity_UOM2%TYPE, --INVCONV
47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.
53: org_id oe_order_lines.org_id%TYPE,
54: report_title VARCHAR2(4),

Line 51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,

47: ship_qty1 oe_order_lines.shipped_quantity%TYPE,
48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.
53: org_id oe_order_lines.org_id%TYPE,
54: report_title VARCHAR2(4),
55: spec_hdr_text_code NUMBER(10) -- Bug # 4260445

Line 52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.

48: ship_qty2 oe_order_lines.shipped_quantity2%TYPE,
49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.
53: org_id oe_order_lines.org_id%TYPE,
54: report_title VARCHAR2(4),
55: spec_hdr_text_code NUMBER(10) -- Bug # 4260445
56: );

Line 53: org_id oe_order_lines.org_id%TYPE,

49: ship_qty_uom1 oe_order_lines.shipping_quantity_uom%TYPE, --Bug # 3710191 added these two lines for the fields ship_uom1 and ship_uom2
50: ship_qty_uom2 oe_order_lines.shipping_quantity_uom2%TYPE, --INVCONV
51: ship_from_org_id oe_order_lines.ship_from_org_id%TYPE,
52: ship_to_site_id oe_order_lines.ship_to_org_id%TYPE, --Bug 4166529 added.
53: org_id oe_order_lines.org_id%TYPE,
54: report_title VARCHAR2(4),
55: spec_hdr_text_code NUMBER(10) -- Bug # 4260445
56: );
57: