40: operation VARCHAR2(30),
41: order_header_id NUMBER,
42: ordered_quantity NUMBER,
43: shipped_quantity NUMBER,
44: primary_quantity rlm_interface_lines.primary_quantity%TYPE,
45: schedule_item_number NUMBER,
46: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
47: ship_to_address_id NUMBER,
48: ship_to_org_id NUMBER,
42: ordered_quantity NUMBER,
43: shipped_quantity NUMBER,
44: primary_quantity rlm_interface_lines.primary_quantity%TYPE,
45: schedule_item_number NUMBER,
46: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
47: ship_to_address_id NUMBER,
48: ship_to_org_id NUMBER,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
46: ship_from_org_id rlm_interface_lines.ship_from_org_id%TYPE,
47: ship_to_address_id NUMBER,
48: ship_to_org_id NUMBER,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
47: ship_to_address_id NUMBER,
48: ship_to_org_id NUMBER,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
48: ship_to_org_id NUMBER,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
49: schedule_type rlm_interface_headers.schedule_type%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
50: price_list_id rlm_interface_lines.price_list_id%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
51: agreement_id rlm_interface_lines.agreement_id%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
52: item_detail_type rlm_interface_lines.item_detail_type%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
53: item_detail_subtype rlm_interface_lines.item_detail_subtype%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
54: supplier_item_ext rlm_interface_lines.supplier_item_ext%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
55: customer_item_ext rlm_interface_lines.customer_item_ext%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
56: delivery_lead_time rlm_interface_lines.delivery_lead_time%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
57: cust_po_number rlm_interface_lines.cust_po_number%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
58: customer_item_revision rlm_interface_lines.customer_item_revision%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
59: customer_dock_code rlm_interface_lines.customer_dock_code%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
60: customer_job rlm_interface_lines.customer_job%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
61: cust_production_line rlm_interface_lines.cust_production_line%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
62: cust_model_serial_number rlm_interface_lines.cust_model_serial_number%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
63: cust_production_seq_num rlm_interface_lines.cust_production_seq_num%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
64: industry_attribute1 rlm_interface_lines.industry_attribute1%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
65: industry_attribute2 rlm_interface_lines.industry_attribute2%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
66: industry_attribute3 rlm_interface_lines.industry_attribute3%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
67: industry_attribute4 rlm_interface_lines.industry_attribute4%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
68: industry_attribute5 rlm_interface_lines.industry_attribute5%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
69: industry_attribute6 rlm_interface_lines.industry_attribute6%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
70: industry_attribute7 rlm_interface_lines.industry_attribute7%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
71: industry_attribute8 rlm_interface_lines.industry_attribute8%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
72: industry_attribute9 rlm_interface_lines.industry_attribute9%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
73: industry_attribute10 rlm_interface_lines.industry_attribute10%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
74: industry_attribute11 rlm_interface_lines.industry_attribute11%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
75: industry_attribute12 rlm_interface_lines.industry_attribute12%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
76: industry_attribute13 rlm_interface_lines.industry_attribute13%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
77: industry_attribute14 rlm_interface_lines.industry_attribute14%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
78: industry_attribute15 rlm_interface_lines.industry_attribute15%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
79: industry_context rlm_interface_lines.industry_context%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
80: attribute1 rlm_interface_lines.attribute1%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
81: attribute2 rlm_interface_lines.attribute2%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
82: attribute3 rlm_interface_lines.attribute3%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
83: attribute4 rlm_interface_lines.attribute4%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
84: attribute5 rlm_interface_lines.attribute5%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
85: attribute6 rlm_interface_lines.attribute6%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
86: attribute7 rlm_interface_lines.attribute7%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
87: attribute8 rlm_interface_lines.attribute8%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
88: attribute9 rlm_interface_lines.attribute9%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
89: attribute10 rlm_interface_lines.attribute10%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
90: attribute11 rlm_interface_lines.attribute11%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
91: attribute12 rlm_interface_lines.attribute12%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
92: attribute13 rlm_interface_lines.attribute13%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
93: attribute14 rlm_interface_lines.attribute14%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
94: attribute15 rlm_interface_lines.attribute15%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
95: attribute_category rlm_interface_lines.attribute_category%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
96: tp_attribute1 rlm_interface_lines.tp_attribute1%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
97: tp_attribute2 rlm_interface_lines.tp_attribute2%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
98: tp_attribute3 rlm_interface_lines.tp_attribute3%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
99: tp_attribute4 rlm_interface_lines.tp_attribute4%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
100: tp_attribute5 rlm_interface_lines.tp_attribute5%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
101: tp_attribute6 rlm_interface_lines.tp_attribute6%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
102: tp_attribute7 rlm_interface_lines.tp_attribute7%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
103: tp_attribute8 rlm_interface_lines.tp_attribute8%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
104: tp_attribute9 rlm_interface_lines.tp_attribute9%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
105: tp_attribute10 rlm_interface_lines.tp_attribute10%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
106: tp_attribute11 rlm_interface_lines.tp_attribute11%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
107: tp_attribute12 rlm_interface_lines.tp_attribute12%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
108: tp_attribute13 rlm_interface_lines.tp_attribute13%TYPE,
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
109: tp_attribute14 rlm_interface_lines.tp_attribute14%TYPE,
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
110: tp_attribute15 rlm_interface_lines.tp_attribute15%TYPE,
111: tp_attribute_category rlm_interface_lines.tp_attribute_category%TYPE,
112: request_date rlm_interface_lines.request_date%TYPE,
113: schedule_date rlm_interface_lines.schedule_date%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
118: process_status rlm_interface_lines.process_status%TYPE,
114: uom_code rlm_interface_lines.uom_code%TYPE,
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
118: process_status rlm_interface_lines.process_status%TYPE,
119: cust_po_line_num rlm_interface_lines.cust_po_line_num%TYPE,
120: blanket_number rlm_interface_lines.blanket_number%TYPE
121: );
122:
115: authorized_to_ship_flag oe_order_lines.authorized_to_ship_flag%TYPE,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
118: process_status rlm_interface_lines.process_status%TYPE,
119: cust_po_line_num rlm_interface_lines.cust_po_line_num%TYPE,
120: blanket_number rlm_interface_lines.blanket_number%TYPE
121: );
122:
123: TYPE t_consume_rec IS RECORD( line_id NUMBER,
116: shipment_flag VARCHAR2(30),
117: item_identifier_type VARCHAR2(25),
118: process_status rlm_interface_lines.process_status%TYPE,
119: cust_po_line_num rlm_interface_lines.cust_po_line_num%TYPE,
120: blanket_number rlm_interface_lines.blanket_number%TYPE
121: );
122:
123: TYPE t_consume_rec IS RECORD( line_id NUMBER,
124: quantity NUMBER);
156: ship_from_org_id NUMBER,
157: intrmd_ship_to_address_id NUMBER,
158: ship_to_address_id NUMBER,
159: bill_to_address_id NUMBER,
160: purchase_order_number rlm_interface_lines.cust_po_number%TYPE,
161: primary_quantity NUMBER,
162: item_detail_quantity NUMBER,
163: start_date_time DATE,
164: cust_record_year rlm_interface_lines.industry_attribute1%TYPE,
160: purchase_order_number rlm_interface_lines.cust_po_number%TYPE,
161: primary_quantity NUMBER,
162: item_detail_quantity NUMBER,
163: start_date_time DATE,
164: cust_record_year rlm_interface_lines.industry_attribute1%TYPE,
165: line_id NUMBER
166: );
167:
168: TYPE t_Ship_tab IS TABLE OF t_Ship_rec INDEX BY BINARY_INTEGER; --Bugfix 7007638
653: /*===========================================================================
654: PROCEDURE NAME: GetReq
655:
656: DESCRIPTION: This procedure will retrieve Requirement attributes from
657: rlm_interface_lines.
658:
659: PARAMETERS: x_Key_rec IN OUT NOCOPY t_Key_rec
660:
661: DESIGN REFERENCES: RLADPRDD.rtf
1463: CHANGE HISTORY: created jhaulund 03/05/99
1464: ===========================================================================*/
1465:
1466: FUNCTION IsLineConsumable(x_consume_tab IN t_consume_tab,
1467: x_line_id IN RLM_INTERFACE_LINES.LINE_ID%TYPE,
1468: x_index OUT NOCOPY NUMBER)
1469: RETURN BOOLEAN;
1470:
1471: /*===========================================================================
2236:
2237: CHANGE HISTORY: created stananth 06/20/05
2238: ===========================================================================*/
2239:
2240: PROCEDURE AssignMatchAttribValues ( x_req_rec IN rlm_interface_lines_all%ROWTYPE,
2241: x_match_rec IN OUT NOCOPY RLM_RD_SV.t_generic_rec);
2242:
2243: /*============================================================================
2244: