APPS.GMD_COA_DATA_NEW dependencies on OP_ORDR_DTL

Line 30: line_id op_ordr_dtl.line_id%TYPE,

26:
27: TYPE t_coa_hdr_rec IS RECORD
28: (gmd_coa_id BINARY_INTEGER,
29: order_id op_ordr_hdr.order_id%TYPE,
30: line_id op_ordr_dtl.line_id%TYPE,
31: orgn_code op_ordr_hdr.orgn_code%TYPE,
32: order_no op_ordr_hdr.order_no%TYPE,
33: custpo_no op_ordr_dtl.custpo_no%TYPE,
34: shipdate op_ordr_dtl.sched_shipdate%TYPE,

Line 33: custpo_no op_ordr_dtl.custpo_no%TYPE,

29: order_id op_ordr_hdr.order_id%TYPE,
30: line_id op_ordr_dtl.line_id%TYPE,
31: orgn_code op_ordr_hdr.orgn_code%TYPE,
32: order_no op_ordr_hdr.order_no%TYPE,
33: custpo_no op_ordr_dtl.custpo_no%TYPE,
34: shipdate op_ordr_dtl.sched_shipdate%TYPE,
35: cust_id op_cust_mst.cust_id%TYPE,
36: cust_no op_cust_mst.custsort_no%TYPE,
37: cust_name op_cust_mst.cust_name%TYPE,

Line 34: shipdate op_ordr_dtl.sched_shipdate%TYPE,

30: line_id op_ordr_dtl.line_id%TYPE,
31: orgn_code op_ordr_hdr.orgn_code%TYPE,
32: order_no op_ordr_hdr.order_no%TYPE,
33: custpo_no op_ordr_dtl.custpo_no%TYPE,
34: shipdate op_ordr_dtl.sched_shipdate%TYPE,
35: cust_id op_cust_mst.cust_id%TYPE,
36: cust_no op_cust_mst.custsort_no%TYPE,
37: cust_name op_cust_mst.cust_name%TYPE,
38: bol_id op_bill_lad.bol_id%TYPE,

Line 49: order_qty1 op_ordr_dtl.order_qty1%TYPE,

45: lot_id ic_lots_mst.lot_id%TYPE,
46: lot_no ic_lots_mst.lot_no%TYPE,
47: lot_desc ic_lots_mst.lot_desc%TYPE,
48: sublot_no ic_lots_mst.sublot_no%TYPE,
49: order_qty1 op_ordr_dtl.order_qty1%TYPE,
50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,

Line 50: order_qty2 op_ordr_dtl.order_qty2%TYPE,

46: lot_no ic_lots_mst.lot_no%TYPE,
47: lot_desc ic_lots_mst.lot_desc%TYPE,
48: sublot_no ic_lots_mst.sublot_no%TYPE,
49: order_qty1 op_ordr_dtl.order_qty1%TYPE,
50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,
54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,

Line 51: order_um1 op_ordr_dtl.order_um1%TYPE,

47: lot_desc ic_lots_mst.lot_desc%TYPE,
48: sublot_no ic_lots_mst.sublot_no%TYPE,
49: order_qty1 op_ordr_dtl.order_qty1%TYPE,
50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,
54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,
55: report_title VARCHAR2(4)

Line 52: order_um2 op_ordr_dtl.order_um2%TYPE,

48: sublot_no ic_lots_mst.sublot_no%TYPE,
49: order_qty1 op_ordr_dtl.order_qty1%TYPE,
50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,
54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,
55: report_title VARCHAR2(4)
56: );

Line 53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,

49: order_qty1 op_ordr_dtl.order_qty1%TYPE,
50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,
54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,
55: report_title VARCHAR2(4)
56: );
57:

Line 54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,

50: order_qty2 op_ordr_dtl.order_qty2%TYPE,
51: order_um1 op_ordr_dtl.order_um1%TYPE,
52: order_um2 op_ordr_dtl.order_um2%TYPE,
53: ship_qty1 op_ordr_dtl.ship_qty1%TYPE,
54: ship_qty2 op_ordr_dtl.ship_qty2%TYPE,
55: report_title VARCHAR2(4)
56: );
57:
58: TYPE t_coa_dtl_rec IS RECORD

Line 86: custpo_no op_ordr_dtl.custpo_no%TYPE,

82:
83: TYPE t_coa_parameters IS RECORD
84: (order_id op_ordr_hdr.order_id%TYPE,
85: orgn_code op_ordr_hdr.orgn_code%TYPE,
86: custpo_no op_ordr_dtl.custpo_no%TYPE,
87: from_shipdate op_ordr_dtl.sched_shipdate%TYPE,
88: to_shipdate op_ordr_dtl.sched_shipdate%TYPE,
89: cust_id op_cust_mst.cust_id%TYPE,
90: bol_id op_bill_lad.bol_id%TYPE,

Line 87: from_shipdate op_ordr_dtl.sched_shipdate%TYPE,

83: TYPE t_coa_parameters IS RECORD
84: (order_id op_ordr_hdr.order_id%TYPE,
85: orgn_code op_ordr_hdr.orgn_code%TYPE,
86: custpo_no op_ordr_dtl.custpo_no%TYPE,
87: from_shipdate op_ordr_dtl.sched_shipdate%TYPE,
88: to_shipdate op_ordr_dtl.sched_shipdate%TYPE,
89: cust_id op_cust_mst.cust_id%TYPE,
90: bol_id op_bill_lad.bol_id%TYPE,
91: item_id ic_item_mst.item_id%TYPE,

Line 88: to_shipdate op_ordr_dtl.sched_shipdate%TYPE,

84: (order_id op_ordr_hdr.order_id%TYPE,
85: orgn_code op_ordr_hdr.orgn_code%TYPE,
86: custpo_no op_ordr_dtl.custpo_no%TYPE,
87: from_shipdate op_ordr_dtl.sched_shipdate%TYPE,
88: to_shipdate op_ordr_dtl.sched_shipdate%TYPE,
89: cust_id op_cust_mst.cust_id%TYPE,
90: bol_id op_bill_lad.bol_id%TYPE,
91: item_id ic_item_mst.item_id%TYPE,
92: whse_code ic_whse_mst.whse_code%TYPE,