8: -- the table
9: TYPE headers_rec_type IS RECORD
10: (
11: -- attributes read from interface table
12: intf_header_id_tbl PO_TBL_NUMBER,
13: draft_id_tbl PO_TBL_NUMBER,
14: po_header_id_tbl PO_TBL_NUMBER,
15: action_tbl PO_TBL_VARCHAR30,
16: document_num_tbl PO_TBL_VARCHAR30,
9: TYPE headers_rec_type IS RECORD
10: (
11: -- attributes read from interface table
12: intf_header_id_tbl PO_TBL_NUMBER,
13: draft_id_tbl PO_TBL_NUMBER,
14: po_header_id_tbl PO_TBL_NUMBER,
15: action_tbl PO_TBL_VARCHAR30,
16: document_num_tbl PO_TBL_VARCHAR30,
17: doc_type_tbl PO_TBL_VARCHAR30,
10: (
11: -- attributes read from interface table
12: intf_header_id_tbl PO_TBL_NUMBER,
13: draft_id_tbl PO_TBL_NUMBER,
14: po_header_id_tbl PO_TBL_NUMBER,
15: action_tbl PO_TBL_VARCHAR30,
16: document_num_tbl PO_TBL_VARCHAR30,
17: doc_type_tbl PO_TBL_VARCHAR30,
18: doc_subtype_tbl PO_TBL_VARCHAR30,
18: doc_subtype_tbl PO_TBL_VARCHAR30,
19: rate_type_tbl PO_TBL_VARCHAR30,
20: rate_type_code_tbl PO_TBL_VARCHAR30,
21: rate_date_tbl PO_TBL_DATE,
22: rate_tbl PO_TBL_NUMBER,
23: agent_id_tbl PO_TBL_NUMBER,
24: agent_name_tbl PO_TBL_VARCHAR2000,
25: ship_to_loc_id_tbl PO_TBL_NUMBER,
26: ship_to_loc_tbl PO_TBL_VARCHAR100,
19: rate_type_tbl PO_TBL_VARCHAR30,
20: rate_type_code_tbl PO_TBL_VARCHAR30,
21: rate_date_tbl PO_TBL_DATE,
22: rate_tbl PO_TBL_NUMBER,
23: agent_id_tbl PO_TBL_NUMBER,
24: agent_name_tbl PO_TBL_VARCHAR2000,
25: ship_to_loc_id_tbl PO_TBL_NUMBER,
26: ship_to_loc_tbl PO_TBL_VARCHAR100,
27: bill_to_loc_id_tbl PO_TBL_NUMBER,
21: rate_date_tbl PO_TBL_DATE,
22: rate_tbl PO_TBL_NUMBER,
23: agent_id_tbl PO_TBL_NUMBER,
24: agent_name_tbl PO_TBL_VARCHAR2000,
25: ship_to_loc_id_tbl PO_TBL_NUMBER,
26: ship_to_loc_tbl PO_TBL_VARCHAR100,
27: bill_to_loc_id_tbl PO_TBL_NUMBER,
28: bill_to_loc_tbl PO_TBL_VARCHAR100,
29: payment_terms_tbl PO_TBL_VARCHAR100,
23: agent_id_tbl PO_TBL_NUMBER,
24: agent_name_tbl PO_TBL_VARCHAR2000,
25: ship_to_loc_id_tbl PO_TBL_NUMBER,
26: ship_to_loc_tbl PO_TBL_VARCHAR100,
27: bill_to_loc_id_tbl PO_TBL_NUMBER,
28: bill_to_loc_tbl PO_TBL_VARCHAR100,
29: payment_terms_tbl PO_TBL_VARCHAR100,
30: terms_id_tbl PO_TBL_NUMBER,
31: vendor_name_tbl PO_TBL_VARCHAR2000,
26: ship_to_loc_tbl PO_TBL_VARCHAR100,
27: bill_to_loc_id_tbl PO_TBL_NUMBER,
28: bill_to_loc_tbl PO_TBL_VARCHAR100,
29: payment_terms_tbl PO_TBL_VARCHAR100,
30: terms_id_tbl PO_TBL_NUMBER,
31: vendor_name_tbl PO_TBL_VARCHAR2000,
32: vendor_num_tbl PO_TBL_VARCHAR30,
33: vendor_id_tbl PO_TBL_NUMBER,
34: vendor_site_code_tbl PO_TBL_VARCHAR30,
29: payment_terms_tbl PO_TBL_VARCHAR100,
30: terms_id_tbl PO_TBL_NUMBER,
31: vendor_name_tbl PO_TBL_VARCHAR2000,
32: vendor_num_tbl PO_TBL_VARCHAR30,
33: vendor_id_tbl PO_TBL_NUMBER,
34: vendor_site_code_tbl PO_TBL_VARCHAR30,
35: vendor_site_id_tbl PO_TBL_NUMBER,
36: vendor_contact_tbl PO_TBL_VARCHAR2000,
37: vendor_contact_id_tbl PO_TBL_NUMBER,
31: vendor_name_tbl PO_TBL_VARCHAR2000,
32: vendor_num_tbl PO_TBL_VARCHAR30,
33: vendor_id_tbl PO_TBL_NUMBER,
34: vendor_site_code_tbl PO_TBL_VARCHAR30,
35: vendor_site_id_tbl PO_TBL_NUMBER,
36: vendor_contact_tbl PO_TBL_VARCHAR2000,
37: vendor_contact_id_tbl PO_TBL_NUMBER,
38: from_rfq_num_tbl PO_TBL_VARCHAR30,
39: from_header_id_tbl PO_TBL_NUMBER,
33: vendor_id_tbl PO_TBL_NUMBER,
34: vendor_site_code_tbl PO_TBL_VARCHAR30,
35: vendor_site_id_tbl PO_TBL_NUMBER,
36: vendor_contact_tbl PO_TBL_VARCHAR2000,
37: vendor_contact_id_tbl PO_TBL_NUMBER,
38: from_rfq_num_tbl PO_TBL_VARCHAR30,
39: from_header_id_tbl PO_TBL_NUMBER,
40: fob_tbl PO_TBL_VARCHAR30,
41: freight_carrier_tbl PO_TBL_VARCHAR30,
35: vendor_site_id_tbl PO_TBL_NUMBER,
36: vendor_contact_tbl PO_TBL_VARCHAR2000,
37: vendor_contact_id_tbl PO_TBL_NUMBER,
38: from_rfq_num_tbl PO_TBL_VARCHAR30,
39: from_header_id_tbl PO_TBL_NUMBER,
40: fob_tbl PO_TBL_VARCHAR30,
41: freight_carrier_tbl PO_TBL_VARCHAR30,
42: freight_term_tbl PO_TBL_VARCHAR30,
43: pay_on_code_tbl PO_TBL_VARCHAR30,
42: freight_term_tbl PO_TBL_VARCHAR30,
43: pay_on_code_tbl PO_TBL_VARCHAR30,
44: shipping_control_tbl PO_TBL_VARCHAR30,
45: currency_code_tbl PO_TBL_VARCHAR30,
46: quote_warning_delay_tbl PO_TBL_NUMBER,
47: approval_required_flag_tbl PO_TBL_VARCHAR1,
48: reply_date_tbl PO_TBL_DATE,
49: approval_status_tbl PO_TBL_VARCHAR30,
50: approved_date_tbl PO_TBL_DATE,
48: reply_date_tbl PO_TBL_DATE,
49: approval_status_tbl PO_TBL_VARCHAR30,
50: approved_date_tbl PO_TBL_DATE,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52: revision_num_tbl PO_TBL_NUMBER,
53: confirming_order_flag_tbl PO_TBL_VARCHAR1,
54: acceptance_required_flag_tbl PO_TBL_VARCHAR1,
55: min_release_amount_tbl PO_TBL_NUMBER,
56: closed_code_tbl PO_TBL_VARCHAR30,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52: revision_num_tbl PO_TBL_NUMBER,
53: confirming_order_flag_tbl PO_TBL_VARCHAR1,
54: acceptance_required_flag_tbl PO_TBL_VARCHAR1,
55: min_release_amount_tbl PO_TBL_NUMBER,
56: closed_code_tbl PO_TBL_VARCHAR30,
57: print_count_tbl PO_TBL_NUMBER,
58: frozen_flag_tbl PO_TBL_VARCHAR1,
59: encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
53: confirming_order_flag_tbl PO_TBL_VARCHAR1,
54: acceptance_required_flag_tbl PO_TBL_VARCHAR1,
55: min_release_amount_tbl PO_TBL_NUMBER,
56: closed_code_tbl PO_TBL_VARCHAR30,
57: print_count_tbl PO_TBL_NUMBER,
58: frozen_flag_tbl PO_TBL_VARCHAR1,
59: encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
61: org_id_tbl PO_TBL_NUMBER,
57: print_count_tbl PO_TBL_NUMBER,
58: frozen_flag_tbl PO_TBL_VARCHAR1,
59: encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
61: org_id_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
59: encumbrance_required_flag_tbl PO_TBL_VARCHAR1,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
61: org_id_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_date_tbl PO_TBL_DATE,
65: expiration_date_tbl PO_TBL_DATE,
66: po_release_id_tbl PO_TBL_NUMBER,
67: release_num_tbl PO_TBL_NUMBER,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
68: release_date_tbl PO_TBL_DATE,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
75: gl_encumbered_date_tbl PO_TBL_DATE,
76: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
69: revised_date_tbl PO_TBL_DATE,
70: printed_date_tbl PO_TBL_DATE,
71: closed_date_tbl PO_TBL_DATE,
72: amount_agreed_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
75: gl_encumbered_date_tbl PO_TBL_DATE,
76: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
77: budget_account_id_tbl PO_TBL_NUMBER,
73: amount_limit_tbl PO_TBL_NUMBER, -- bug5352625
74: firm_flag_tbl PO_TBL_VARCHAR30,
75: gl_encumbered_date_tbl PO_TBL_DATE,
76: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
77: budget_account_id_tbl PO_TBL_NUMBER,
78: budget_account_tbl PO_TBL_VARCHAR2000,
79: budget_account_segment1_tbl PO_TBL_VARCHAR30,
80: budget_account_segment2_tbl PO_TBL_VARCHAR30,
81: budget_account_segment3_tbl PO_TBL_VARCHAR30,
106: budget_account_segment28_tbl PO_TBL_VARCHAR30,
107: budget_account_segment29_tbl PO_TBL_VARCHAR30,
108: budget_account_segment30_tbl PO_TBL_VARCHAR30,
109: created_language_tbl PO_TBL_VARCHAR5,
110: style_id_tbl PO_TBL_NUMBER,
111: style_display_name_tbl PO_TBL_VARCHAR2000,
112: global_agreement_flag_tbl PO_TBL_VARCHAR1,
113:
114: -- standard who columns
112: global_agreement_flag_tbl PO_TBL_VARCHAR1,
113:
114: -- standard who columns
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
113:
114: -- standard who columns
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
123: program_update_date_tbl PO_TBL_DATE,
116: last_updated_by_tbl PO_TBL_NUMBER,
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
123: program_update_date_tbl PO_TBL_DATE,
124:
117: last_update_login_tbl PO_TBL_NUMBER,
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
123: program_update_date_tbl PO_TBL_DATE,
124:
125: -- attributes not read from interface table but exist in txn table
118: creation_date_tbl PO_TBL_DATE,
119: created_by_tbl PO_TBL_NUMBER,
120: request_id_tbl PO_TBL_NUMBER,
121: program_application_id_tbl PO_TBL_NUMBER,
122: program_id_tbl PO_TBL_NUMBER,
123: program_update_date_tbl PO_TBL_DATE,
124:
125: -- attributes not read from interface table but exist in txn table
126: status_lookup_code_tbl PO_TBL_VARCHAR30,
130: doc_creation_method_tbl PO_TBL_VARCHAR30,
131: quotation_class_code_tbl PO_TBL_VARCHAR30,
132: approved_flag_tbl PO_TBL_VARCHAR1,
133: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
134: po_dist_id_tbl PO_TBL_NUMBER,
135:
136: -- attributes added for processing purpose
137: error_flag_tbl PO_TBL_VARCHAR1,
138: rec_count NUMBER,
150: -- the table
151: TYPE lines_rec_type IS RECORD
152: (
153: -- attributes read from line interface records
154: intf_line_id_tbl PO_TBL_NUMBER,
155: intf_header_id_tbl PO_TBL_NUMBER,
156: po_header_id_tbl PO_TBL_NUMBER,
157: po_line_id_tbl PO_TBL_NUMBER,
158: action_tbl PO_TBL_VARCHAR30,
151: TYPE lines_rec_type IS RECORD
152: (
153: -- attributes read from line interface records
154: intf_line_id_tbl PO_TBL_NUMBER,
155: intf_header_id_tbl PO_TBL_NUMBER,
156: po_header_id_tbl PO_TBL_NUMBER,
157: po_line_id_tbl PO_TBL_NUMBER,
158: action_tbl PO_TBL_VARCHAR30,
159: document_num_tbl PO_TBL_VARCHAR30,
152: (
153: -- attributes read from line interface records
154: intf_line_id_tbl PO_TBL_NUMBER,
155: intf_header_id_tbl PO_TBL_NUMBER,
156: po_header_id_tbl PO_TBL_NUMBER,
157: po_line_id_tbl PO_TBL_NUMBER,
158: action_tbl PO_TBL_VARCHAR30,
159: document_num_tbl PO_TBL_VARCHAR30,
160: item_tbl PO_TBL_VARCHAR2000,
153: -- attributes read from line interface records
154: intf_line_id_tbl PO_TBL_NUMBER,
155: intf_header_id_tbl PO_TBL_NUMBER,
156: po_header_id_tbl PO_TBL_NUMBER,
157: po_line_id_tbl PO_TBL_NUMBER,
158: action_tbl PO_TBL_VARCHAR30,
159: document_num_tbl PO_TBL_VARCHAR30,
160: item_tbl PO_TBL_VARCHAR2000,
161: vendor_product_num_tbl PO_TBL_VARCHAR30,
159: document_num_tbl PO_TBL_VARCHAR30,
160: item_tbl PO_TBL_VARCHAR2000,
161: vendor_product_num_tbl PO_TBL_VARCHAR30,
162: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
163: item_id_tbl PO_TBL_NUMBER,
164: item_revision_tbl PO_TBL_VARCHAR5,
165: job_business_group_name_tbl PO_TBL_VARCHAR2000,
166: job_business_group_id_tbl PO_TBL_NUMBER,
167: job_name_tbl PO_TBL_VARCHAR2000,
162: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
163: item_id_tbl PO_TBL_NUMBER,
164: item_revision_tbl PO_TBL_VARCHAR5,
165: job_business_group_name_tbl PO_TBL_VARCHAR2000,
166: job_business_group_id_tbl PO_TBL_NUMBER,
167: job_name_tbl PO_TBL_VARCHAR2000,
168: job_id_tbl PO_TBL_NUMBER,
169: category_tbl PO_TBL_VARCHAR2000,
170: category_id_tbl PO_TBL_NUMBER,
164: item_revision_tbl PO_TBL_VARCHAR5,
165: job_business_group_name_tbl PO_TBL_VARCHAR2000,
166: job_business_group_id_tbl PO_TBL_NUMBER,
167: job_name_tbl PO_TBL_VARCHAR2000,
168: job_id_tbl PO_TBL_NUMBER,
169: category_tbl PO_TBL_VARCHAR2000,
170: category_id_tbl PO_TBL_NUMBER,
171: ip_category_tbl PO_TBL_VARCHAR2000,
172: ip_category_id_tbl PO_TBL_NUMBER,
166: job_business_group_id_tbl PO_TBL_NUMBER,
167: job_name_tbl PO_TBL_VARCHAR2000,
168: job_id_tbl PO_TBL_NUMBER,
169: category_tbl PO_TBL_VARCHAR2000,
170: category_id_tbl PO_TBL_NUMBER,
171: ip_category_tbl PO_TBL_VARCHAR2000,
172: ip_category_id_tbl PO_TBL_NUMBER,
173: uom_code_tbl PO_TBL_VARCHAR5,
174: unit_of_measure_tbl PO_TBL_VARCHAR30,
168: job_id_tbl PO_TBL_NUMBER,
169: category_tbl PO_TBL_VARCHAR2000,
170: category_id_tbl PO_TBL_NUMBER,
171: ip_category_tbl PO_TBL_VARCHAR2000,
172: ip_category_id_tbl PO_TBL_NUMBER,
173: uom_code_tbl PO_TBL_VARCHAR5,
174: unit_of_measure_tbl PO_TBL_VARCHAR30,
175: line_type_tbl PO_TBL_VARCHAR30,
176: line_type_id_tbl PO_TBL_NUMBER,
172: ip_category_id_tbl PO_TBL_NUMBER,
173: uom_code_tbl PO_TBL_VARCHAR5,
174: unit_of_measure_tbl PO_TBL_VARCHAR30,
175: line_type_tbl PO_TBL_VARCHAR30,
176: line_type_id_tbl PO_TBL_NUMBER,
177: un_number_tbl PO_TBL_VARCHAR30,
178: un_number_id_tbl PO_TBL_NUMBER,
179: hazard_class_tbl PO_TBL_VARCHAR100,
180: hazard_class_id_tbl PO_TBL_NUMBER,
174: unit_of_measure_tbl PO_TBL_VARCHAR30,
175: line_type_tbl PO_TBL_VARCHAR30,
176: line_type_id_tbl PO_TBL_NUMBER,
177: un_number_tbl PO_TBL_VARCHAR30,
178: un_number_id_tbl PO_TBL_NUMBER,
179: hazard_class_tbl PO_TBL_VARCHAR100,
180: hazard_class_id_tbl PO_TBL_NUMBER,
181: template_name_tbl PO_TBL_VARCHAR30,
182: template_id_tbl PO_TBL_NUMBER,
176: line_type_id_tbl PO_TBL_NUMBER,
177: un_number_tbl PO_TBL_VARCHAR30,
178: un_number_id_tbl PO_TBL_NUMBER,
179: hazard_class_tbl PO_TBL_VARCHAR100,
180: hazard_class_id_tbl PO_TBL_NUMBER,
181: template_name_tbl PO_TBL_VARCHAR30,
182: template_id_tbl PO_TBL_NUMBER,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
178: un_number_id_tbl PO_TBL_NUMBER,
179: hazard_class_tbl PO_TBL_VARCHAR100,
180: hazard_class_id_tbl PO_TBL_NUMBER,
181: template_name_tbl PO_TBL_VARCHAR30,
182: template_id_tbl PO_TBL_NUMBER,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
180: hazard_class_id_tbl PO_TBL_NUMBER,
181: template_name_tbl PO_TBL_VARCHAR30,
182: template_id_tbl PO_TBL_NUMBER,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
181: template_name_tbl PO_TBL_VARCHAR30,
182: template_id_tbl PO_TBL_NUMBER,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
182: template_id_tbl PO_TBL_NUMBER,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
190: capital_expense_flag_tbl PO_TBL_VARCHAR1,
183: item_desc_tbl PO_TBL_VARCHAR2000,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
190: capital_expense_flag_tbl PO_TBL_VARCHAR1,
191: min_release_amount_tbl PO_TBL_NUMBER,
184: unit_price_tbl PO_TBL_NUMBER,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
190: capital_expense_flag_tbl PO_TBL_VARCHAR1,
191: min_release_amount_tbl PO_TBL_NUMBER,
192: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
185: base_unit_price_tbl PO_TBL_NUMBER,
186: from_header_id_tbl PO_TBL_NUMBER,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
190: capital_expense_flag_tbl PO_TBL_VARCHAR1,
191: min_release_amount_tbl PO_TBL_NUMBER,
192: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
193: price_type_tbl PO_TBL_VARCHAR30,
187: from_line_id_tbl PO_TBL_NUMBER,
188: list_price_per_unit_tbl PO_TBL_NUMBER,
189: market_price_tbl PO_TBL_NUMBER,
190: capital_expense_flag_tbl PO_TBL_VARCHAR1,
191: min_release_amount_tbl PO_TBL_NUMBER,
192: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
193: price_type_tbl PO_TBL_VARCHAR30,
194: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
195: closed_code_tbl PO_TBL_VARCHAR30,
192: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
193: price_type_tbl PO_TBL_VARCHAR30,
194: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
195: closed_code_tbl PO_TBL_VARCHAR30,
196: quantity_tbl PO_TBL_NUMBER,
197: line_num_tbl PO_TBL_NUMBER,
198: shipment_num_tbl PO_TBL_NUMBER,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
193: price_type_tbl PO_TBL_VARCHAR30,
194: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
195: closed_code_tbl PO_TBL_VARCHAR30,
196: quantity_tbl PO_TBL_NUMBER,
197: line_num_tbl PO_TBL_NUMBER,
198: shipment_num_tbl PO_TBL_NUMBER,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
201: expiration_date_tbl PO_TBL_DATE,
194: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
195: closed_code_tbl PO_TBL_VARCHAR30,
196: quantity_tbl PO_TBL_NUMBER,
197: line_num_tbl PO_TBL_NUMBER,
198: shipment_num_tbl PO_TBL_NUMBER,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
201: expiration_date_tbl PO_TBL_DATE,
202: attribute14_tbl PO_TBL_VARCHAR2000,
199: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
200: effective_date_tbl PO_TBL_DATE,
201: expiration_date_tbl PO_TBL_DATE,
202: attribute14_tbl PO_TBL_VARCHAR2000,
203: price_update_tolerance_tbl PO_TBL_NUMBER,
204: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
205: negotiated_flag_tbl PO_TBL_VARCHAR1,
206: amount_tbl PO_TBL_NUMBER,
207: contractor_last_name_tbl PO_TBL_VARCHAR2000,
202: attribute14_tbl PO_TBL_VARCHAR2000,
203: price_update_tolerance_tbl PO_TBL_NUMBER,
204: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
205: negotiated_flag_tbl PO_TBL_VARCHAR1,
206: amount_tbl PO_TBL_NUMBER,
207: contractor_last_name_tbl PO_TBL_VARCHAR2000,
208: contractor_first_name_tbl PO_TBL_VARCHAR2000,
209: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210: not_to_exceed_price_tbl PO_TBL_NUMBER,
206: amount_tbl PO_TBL_NUMBER,
207: contractor_last_name_tbl PO_TBL_VARCHAR2000,
208: contractor_first_name_tbl PO_TBL_VARCHAR2000,
209: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210: not_to_exceed_price_tbl PO_TBL_NUMBER,
211: po_release_id_tbl PO_TBL_NUMBER,
212: release_num_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
207: contractor_last_name_tbl PO_TBL_VARCHAR2000,
208: contractor_first_name_tbl PO_TBL_VARCHAR2000,
209: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210: not_to_exceed_price_tbl PO_TBL_NUMBER,
211: po_release_id_tbl PO_TBL_NUMBER,
212: release_num_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
208: contractor_first_name_tbl PO_TBL_VARCHAR2000,
209: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210: not_to_exceed_price_tbl PO_TBL_NUMBER,
211: po_release_id_tbl PO_TBL_NUMBER,
212: release_num_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
209: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
210: not_to_exceed_price_tbl PO_TBL_NUMBER,
211: po_release_id_tbl PO_TBL_NUMBER,
212: release_num_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
217: closed_by_tbl PO_TBL_NUMBER,
211: po_release_id_tbl PO_TBL_NUMBER,
212: release_num_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
217: closed_by_tbl PO_TBL_NUMBER,
218: closed_date_tbl PO_TBL_DATE,
219: committed_amount_tbl PO_TBL_NUMBER,
213: source_shipment_id_tbl PO_TBL_NUMBER,
214: contract_num_tbl PO_TBL_VARCHAR30,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
217: closed_by_tbl PO_TBL_NUMBER,
218: closed_date_tbl PO_TBL_DATE,
219: committed_amount_tbl PO_TBL_NUMBER,
220: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
221: weight_uom_code_tbl PO_TBL_VARCHAR5,
215: contract_id_tbl PO_TBL_NUMBER,
216: type_1099_tbl PO_TBL_VARCHAR30,
217: closed_by_tbl PO_TBL_NUMBER,
218: closed_date_tbl PO_TBL_DATE,
219: committed_amount_tbl PO_TBL_NUMBER,
220: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
221: weight_uom_code_tbl PO_TBL_VARCHAR5,
222: volume_uom_code_tbl PO_TBL_VARCHAR5,
223: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
220: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
221: weight_uom_code_tbl PO_TBL_VARCHAR5,
222: volume_uom_code_tbl PO_TBL_VARCHAR5,
223: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
224: secondary_quantity_tbl PO_TBL_NUMBER,
225: preferred_grade_tbl PO_TBL_VARCHAR2000,
226: process_code_tbl PO_TBL_VARCHAR30,
227: parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
228: file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
223: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
224: secondary_quantity_tbl PO_TBL_NUMBER,
225: preferred_grade_tbl PO_TBL_VARCHAR2000,
226: process_code_tbl PO_TBL_VARCHAR30,
227: parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
228: file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
229:
230: -- standard who columns
231: last_updated_by_tbl PO_TBL_NUMBER,
227: parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
228: file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
229:
230: -- standard who columns
231: last_updated_by_tbl PO_TBL_NUMBER,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
229:
230: -- standard who columns
231: last_updated_by_tbl PO_TBL_NUMBER,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
231: last_updated_by_tbl PO_TBL_NUMBER,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
239: program_update_date_tbl PO_TBL_DATE,
232: last_update_date_tbl PO_TBL_DATE,
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
239: program_update_date_tbl PO_TBL_DATE,
240:
233: last_update_login_tbl PO_TBL_NUMBER,
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
239: program_update_date_tbl PO_TBL_DATE,
240:
241: -- attributes that are in line txn table but not in interface table
234: creation_date_tbl PO_TBL_DATE,
235: created_by_tbl PO_TBL_NUMBER,
236: request_id_tbl PO_TBL_NUMBER,
237: program_application_id_tbl PO_TBL_NUMBER,
238: program_id_tbl PO_TBL_NUMBER,
239: program_update_date_tbl PO_TBL_DATE,
240:
241: -- attributes that are in line txn table but not in interface table
242: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
243: purchase_basis_tbl PO_TBL_VARCHAR30,
244: matching_basis_tbl PO_TBL_VARCHAR30,
245: unordered_flag_tbl PO_TBL_VARCHAR1,
246: cancel_flag_tbl PO_TBL_VARCHAR1,
247: quantity_committed_tbl PO_TBL_NUMBER,
248: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
249:
250: -- attributes read from the header interface record
251: draft_id_tbl PO_TBL_NUMBER,
247: quantity_committed_tbl PO_TBL_NUMBER,
248: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
249:
250: -- attributes read from the header interface record
251: draft_id_tbl PO_TBL_NUMBER,
252: hd_action_tbl PO_TBL_VARCHAR30,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
249:
250: -- attributes read from the header interface record
251: draft_id_tbl PO_TBL_NUMBER,
252: hd_action_tbl PO_TBL_VARCHAR30,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
256: hd_start_date_tbl PO_TBL_DATE,
257: hd_end_date_tbl PO_TBL_DATE,
250: -- attributes read from the header interface record
251: draft_id_tbl PO_TBL_NUMBER,
252: hd_action_tbl PO_TBL_VARCHAR30,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
256: hd_start_date_tbl PO_TBL_DATE,
257: hd_end_date_tbl PO_TBL_DATE,
258: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
251: draft_id_tbl PO_TBL_NUMBER,
252: hd_action_tbl PO_TBL_VARCHAR30,
253: hd_po_header_id_tbl PO_TBL_NUMBER,
254: hd_vendor_id_tbl PO_TBL_NUMBER,
255: hd_min_release_amount_tbl PO_TBL_NUMBER,
256: hd_start_date_tbl PO_TBL_DATE,
257: hd_end_date_tbl PO_TBL_DATE,
258: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
259: hd_currency_code_tbl PO_TBL_VARCHAR30,
257: hd_end_date_tbl PO_TBL_DATE,
258: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
259: hd_currency_code_tbl PO_TBL_VARCHAR30,
260: hd_created_language_tbl PO_TBL_VARCHAR5,
261: hd_style_id_tbl PO_TBL_NUMBER,
262: hd_rate_type_tbl PO_TBL_VARCHAR30,
263:
264: -- attributes added for location processing
265: create_line_loc_tbl PO_TBL_VARCHAR1,
264: -- attributes added for location processing
265: create_line_loc_tbl PO_TBL_VARCHAR1,
266:
267: -- attributes added for uniqueness checking
268: origin_line_num_tbl PO_TBL_NUMBER,
269: group_num_tbl PO_TBL_NUMBER,
270: match_line_found_tbl PO_TBL_VARCHAR1,
271: line_num_unique_tbl PO_TBL_VARCHAR1,
272:
265: create_line_loc_tbl PO_TBL_VARCHAR1,
266:
267: -- attributes added for uniqueness checking
268: origin_line_num_tbl PO_TBL_NUMBER,
269: group_num_tbl PO_TBL_NUMBER,
270: match_line_found_tbl PO_TBL_VARCHAR1,
271: line_num_unique_tbl PO_TBL_VARCHAR1,
272:
273: -- attributes added for processing purpose
288: -- the table
289: TYPE line_locs_rec_type IS RECORD
290: (
291: -- attributes read from line location interface records
292: intf_line_loc_id_tbl PO_TBL_NUMBER,
293: intf_line_id_tbl PO_TBL_NUMBER,
294: intf_header_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
289: TYPE line_locs_rec_type IS RECORD
290: (
291: -- attributes read from line location interface records
292: intf_line_loc_id_tbl PO_TBL_NUMBER,
293: intf_line_id_tbl PO_TBL_NUMBER,
294: intf_header_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
297: line_loc_id_tbl PO_TBL_NUMBER,
290: (
291: -- attributes read from line location interface records
292: intf_line_loc_id_tbl PO_TBL_NUMBER,
293: intf_line_id_tbl PO_TBL_NUMBER,
294: intf_header_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
297: line_loc_id_tbl PO_TBL_NUMBER,
298: ship_to_org_code_tbl PO_TBL_VARCHAR5,
291: -- attributes read from line location interface records
292: intf_line_loc_id_tbl PO_TBL_NUMBER,
293: intf_line_id_tbl PO_TBL_NUMBER,
294: intf_header_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
297: line_loc_id_tbl PO_TBL_NUMBER,
298: ship_to_org_code_tbl PO_TBL_VARCHAR5,
299: ship_to_org_id_tbl PO_TBL_NUMBER,
293: intf_line_id_tbl PO_TBL_NUMBER,
294: intf_header_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
297: line_loc_id_tbl PO_TBL_NUMBER,
298: ship_to_org_code_tbl PO_TBL_VARCHAR5,
299: ship_to_org_id_tbl PO_TBL_NUMBER,
300: ship_to_loc_tbl PO_TBL_VARCHAR100,
301: ship_to_loc_id_tbl PO_TBL_NUMBER,
295: shipment_num_tbl PO_TBL_NUMBER,
296: shipment_type_tbl PO_TBL_VARCHAR30,
297: line_loc_id_tbl PO_TBL_NUMBER,
298: ship_to_org_code_tbl PO_TBL_VARCHAR5,
299: ship_to_org_id_tbl PO_TBL_NUMBER,
300: ship_to_loc_tbl PO_TBL_VARCHAR100,
301: ship_to_loc_id_tbl PO_TBL_NUMBER,
302: payment_terms_tbl PO_TBL_VARCHAR100,
303: terms_id_tbl PO_TBL_NUMBER,
297: line_loc_id_tbl PO_TBL_NUMBER,
298: ship_to_org_code_tbl PO_TBL_VARCHAR5,
299: ship_to_org_id_tbl PO_TBL_NUMBER,
300: ship_to_loc_tbl PO_TBL_VARCHAR100,
301: ship_to_loc_id_tbl PO_TBL_NUMBER,
302: payment_terms_tbl PO_TBL_VARCHAR100,
303: terms_id_tbl PO_TBL_NUMBER,
304: receiving_routing_tbl PO_TBL_VARCHAR30,
305: receiving_routing_id_tbl PO_TBL_NUMBER,
299: ship_to_org_id_tbl PO_TBL_NUMBER,
300: ship_to_loc_tbl PO_TBL_VARCHAR100,
301: ship_to_loc_id_tbl PO_TBL_NUMBER,
302: payment_terms_tbl PO_TBL_VARCHAR100,
303: terms_id_tbl PO_TBL_NUMBER,
304: receiving_routing_tbl PO_TBL_VARCHAR30,
305: receiving_routing_id_tbl PO_TBL_NUMBER,
306: inspection_required_flag_tbl PO_TBL_VARCHAR1,
307: receipt_required_flag_tbl PO_TBL_VARCHAR1,
301: ship_to_loc_id_tbl PO_TBL_NUMBER,
302: payment_terms_tbl PO_TBL_VARCHAR100,
303: terms_id_tbl PO_TBL_NUMBER,
304: receiving_routing_tbl PO_TBL_VARCHAR30,
305: receiving_routing_id_tbl PO_TBL_NUMBER,
306: inspection_required_flag_tbl PO_TBL_VARCHAR1,
307: receipt_required_flag_tbl PO_TBL_VARCHAR1,
308: price_override_tbl PO_TBL_NUMBER,
309: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
304: receiving_routing_tbl PO_TBL_VARCHAR30,
305: receiving_routing_id_tbl PO_TBL_NUMBER,
306: inspection_required_flag_tbl PO_TBL_VARCHAR1,
307: receipt_required_flag_tbl PO_TBL_VARCHAR1,
308: price_override_tbl PO_TBL_NUMBER,
309: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
310: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
311: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
312: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
305: receiving_routing_id_tbl PO_TBL_NUMBER,
306: inspection_required_flag_tbl PO_TBL_VARCHAR1,
307: receipt_required_flag_tbl PO_TBL_VARCHAR1,
308: price_override_tbl PO_TBL_NUMBER,
309: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
310: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
311: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
312: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
313: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
309: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
310: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
311: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
312: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
313: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
314: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
315: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
316: invoice_close_tolerance_tbl PO_TBL_NUMBER,
317: receive_close_tolerance_tbl PO_TBL_NUMBER,
310: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
311: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
312: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
313: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
314: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
315: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
316: invoice_close_tolerance_tbl PO_TBL_NUMBER,
317: receive_close_tolerance_tbl PO_TBL_NUMBER,
318: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
312: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
313: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
314: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
315: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
316: invoice_close_tolerance_tbl PO_TBL_NUMBER,
317: receive_close_tolerance_tbl PO_TBL_NUMBER,
318: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
319: firm_flag_tbl PO_TBL_VARCHAR30,
320: fob_tbl PO_TBL_VARCHAR30,
313: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
314: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
315: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
316: invoice_close_tolerance_tbl PO_TBL_NUMBER,
317: receive_close_tolerance_tbl PO_TBL_NUMBER,
318: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
319: firm_flag_tbl PO_TBL_VARCHAR30,
320: fob_tbl PO_TBL_VARCHAR30,
321: freight_carrier_tbl PO_TBL_VARCHAR30,
321: freight_carrier_tbl PO_TBL_VARCHAR30,
322: freight_term_tbl PO_TBL_VARCHAR30,
323: need_by_date_tbl PO_TBL_DATE,
324: promised_date_tbl PO_TBL_DATE,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
329: price_discount_tbl PO_TBL_NUMBER,
325: quantity_tbl PO_TBL_NUMBER,
326: start_date_tbl PO_TBL_DATE,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
329: price_discount_tbl PO_TBL_NUMBER,
330: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
331: secondary_quantity_tbl PO_TBL_NUMBER,
332: preferred_grade_tbl PO_TBL_VARCHAR2000,
333: tax_code_id_tbl PO_TBL_NUMBER,
327: end_date_tbl PO_TBL_DATE,
328: note_to_receiver_tbl PO_TBL_VARCHAR2000,
329: price_discount_tbl PO_TBL_NUMBER,
330: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
331: secondary_quantity_tbl PO_TBL_NUMBER,
332: preferred_grade_tbl PO_TBL_VARCHAR2000,
333: tax_code_id_tbl PO_TBL_NUMBER,
334: tax_name_tbl PO_TBL_VARCHAR30,
335: taxable_flag_tbl PO_TBL_VARCHAR1,
329: price_discount_tbl PO_TBL_NUMBER,
330: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
331: secondary_quantity_tbl PO_TBL_NUMBER,
332: preferred_grade_tbl PO_TBL_VARCHAR2000,
333: tax_code_id_tbl PO_TBL_NUMBER,
334: tax_name_tbl PO_TBL_VARCHAR30,
335: taxable_flag_tbl PO_TBL_VARCHAR1,
336: unit_of_measure_tbl PO_TBL_VARCHAR30,
337: value_basis_tbl PO_TBL_VARCHAR30,
338: matching_basis_tbl PO_TBL_VARCHAR30,
339:
340: -- attributes in txn table but not in interface table
341: match_option_tbl PO_TBL_VARCHAR30,
342: txn_flow_header_id_tbl PO_TBL_NUMBER,
343: outsourced_assembly_tbl PO_TBL_NUMBER,
344: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
345:
346: -- standard who columns
339:
340: -- attributes in txn table but not in interface table
341: match_option_tbl PO_TBL_VARCHAR30,
342: txn_flow_header_id_tbl PO_TBL_NUMBER,
343: outsourced_assembly_tbl PO_TBL_NUMBER,
344: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
345:
346: -- standard who columns
347: last_updated_by_tbl PO_TBL_NUMBER,
343: outsourced_assembly_tbl PO_TBL_NUMBER,
344: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
345:
346: -- standard who columns
347: last_updated_by_tbl PO_TBL_NUMBER,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
345:
346: -- standard who columns
347: last_updated_by_tbl PO_TBL_NUMBER,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
347: last_updated_by_tbl PO_TBL_NUMBER,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
348: last_update_date_tbl PO_TBL_DATE,
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
349: last_update_login_tbl PO_TBL_NUMBER,
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
357: -- attributes read from the line interface record
350: creation_date_tbl PO_TBL_DATE,
351: created_by_tbl PO_TBL_NUMBER,
352: request_id_tbl PO_TBL_NUMBER,
353: program_application_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
357: -- attributes read from the line interface record
358: ln_po_line_id_tbl PO_TBL_NUMBER,
354: program_id_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
357: -- attributes read from the line interface record
358: ln_po_line_id_tbl PO_TBL_NUMBER,
359: ln_item_id_tbl PO_TBL_NUMBER,
360: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
361: ln_action_tbl PO_TBL_VARCHAR30,
362: ln_unit_price_tbl PO_TBL_NUMBER,
355: program_update_date_tbl PO_TBL_DATE,
356:
357: -- attributes read from the line interface record
358: ln_po_line_id_tbl PO_TBL_NUMBER,
359: ln_item_id_tbl PO_TBL_NUMBER,
360: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
361: ln_action_tbl PO_TBL_VARCHAR30,
362: ln_unit_price_tbl PO_TBL_NUMBER,
363: ln_line_type_id_tbl PO_TBL_NUMBER,
358: ln_po_line_id_tbl PO_TBL_NUMBER,
359: ln_item_id_tbl PO_TBL_NUMBER,
360: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
361: ln_action_tbl PO_TBL_VARCHAR30,
362: ln_unit_price_tbl PO_TBL_NUMBER,
363: ln_line_type_id_tbl PO_TBL_NUMBER,
364: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
365: ln_closed_code_tbl PO_TBL_VARCHAR30,
366: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
359: ln_item_id_tbl PO_TBL_NUMBER,
360: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
361: ln_action_tbl PO_TBL_VARCHAR30,
362: ln_unit_price_tbl PO_TBL_NUMBER,
363: ln_line_type_id_tbl PO_TBL_NUMBER,
364: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
365: ln_closed_code_tbl PO_TBL_VARCHAR30,
366: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
367: ln_matching_basis_tbl PO_TBL_VARCHAR30,
369: ln_expiration_date_tbl PO_TBL_DATE,
370: ln_government_context_tbl PO_TBL_VARCHAR30,
371: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372: ln_closed_date_tbl PO_TBL_DATE,
373: ln_closed_by_tbl PO_TBL_NUMBER,
374: ln_from_header_id_tbl PO_TBL_NUMBER,
375: ln_from_line_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377:
370: ln_government_context_tbl PO_TBL_VARCHAR30,
371: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372: ln_closed_date_tbl PO_TBL_DATE,
373: ln_closed_by_tbl PO_TBL_NUMBER,
374: ln_from_header_id_tbl PO_TBL_NUMBER,
375: ln_from_line_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377:
378: -- attributes read from the header interface record
371: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
372: ln_closed_date_tbl PO_TBL_DATE,
373: ln_closed_by_tbl PO_TBL_NUMBER,
374: ln_from_header_id_tbl PO_TBL_NUMBER,
375: ln_from_line_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377:
378: -- attributes read from the header interface record
379: draft_id_tbl PO_TBL_NUMBER,
375: ln_from_line_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377:
378: -- attributes read from the header interface record
379: draft_id_tbl PO_TBL_NUMBER,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
376: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
377:
378: -- attributes read from the header interface record
379: draft_id_tbl PO_TBL_NUMBER,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
384: hd_terms_id_tbl PO_TBL_NUMBER,
377:
378: -- attributes read from the header interface record
379: draft_id_tbl PO_TBL_NUMBER,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
384: hd_terms_id_tbl PO_TBL_NUMBER,
385: hd_fob_tbl PO_TBL_VARCHAR30,
378: -- attributes read from the header interface record
379: draft_id_tbl PO_TBL_NUMBER,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
384: hd_terms_id_tbl PO_TBL_NUMBER,
385: hd_fob_tbl PO_TBL_VARCHAR30,
386: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
379: draft_id_tbl PO_TBL_NUMBER,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
384: hd_terms_id_tbl PO_TBL_NUMBER,
385: hd_fob_tbl PO_TBL_VARCHAR30,
386: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
387: hd_freight_term_tbl PO_TBL_VARCHAR30,
380: hd_po_header_id_tbl PO_TBL_NUMBER,
381: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
382: hd_vendor_id_tbl PO_TBL_NUMBER,
383: hd_vendor_site_id_tbl PO_TBL_NUMBER,
384: hd_terms_id_tbl PO_TBL_NUMBER,
385: hd_fob_tbl PO_TBL_VARCHAR30,
386: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
387: hd_freight_term_tbl PO_TBL_VARCHAR30,
388: hd_approved_flag_tbl PO_TBL_VARCHAR1,
387: hd_freight_term_tbl PO_TBL_VARCHAR30,
388: hd_approved_flag_tbl PO_TBL_VARCHAR1,
389: hd_effective_date_tbl PO_TBL_DATE,
390: hd_expiration_date_tbl PO_TBL_DATE,
391: hd_style_id_tbl PO_TBL_NUMBER,
392:
393: -- attributes added for item processing(read from line)
394: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
395: ln_unit_weight_tbl PO_TBL_NUMBER,
390: hd_expiration_date_tbl PO_TBL_DATE,
391: hd_style_id_tbl PO_TBL_NUMBER,
392:
393: -- attributes added for item processing(read from line)
394: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
395: ln_unit_weight_tbl PO_TBL_NUMBER,
396: ln_unit_volume_tbl PO_TBL_NUMBER,
397: ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
398: ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
391: hd_style_id_tbl PO_TBL_NUMBER,
392:
393: -- attributes added for item processing(read from line)
394: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
395: ln_unit_weight_tbl PO_TBL_NUMBER,
396: ln_unit_volume_tbl PO_TBL_NUMBER,
397: ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
398: ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
399: ln_item_attribute2_tbl PO_TBL_VARCHAR2000,
392:
393: -- attributes added for item processing(read from line)
394: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
395: ln_unit_weight_tbl PO_TBL_NUMBER,
396: ln_unit_volume_tbl PO_TBL_NUMBER,
397: ln_item_attribute_category_tbl PO_TBL_VARCHAR2000,
398: ln_item_attribute1_tbl PO_TBL_VARCHAR2000,
399: ln_item_attribute2_tbl PO_TBL_VARCHAR2000,
400: ln_item_attribute3_tbl PO_TBL_VARCHAR2000,
411: ln_item_attribute14_tbl PO_TBL_VARCHAR2000,
412: ln_item_attribute15_tbl PO_TBL_VARCHAR2000,
413: ln_item_tbl PO_TBL_VARCHAR2000,
414: ln_item_desc_tbl PO_TBL_VARCHAR2000,
415: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
416: ln_market_price_tbl PO_TBL_NUMBER,
417: ln_un_number_id_tbl PO_TBL_NUMBER,
418: ln_hazard_class_id_tbl PO_TBL_NUMBER,
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
412: ln_item_attribute15_tbl PO_TBL_VARCHAR2000,
413: ln_item_tbl PO_TBL_VARCHAR2000,
414: ln_item_desc_tbl PO_TBL_VARCHAR2000,
415: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
416: ln_market_price_tbl PO_TBL_NUMBER,
417: ln_un_number_id_tbl PO_TBL_NUMBER,
418: ln_hazard_class_id_tbl PO_TBL_NUMBER,
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
413: ln_item_tbl PO_TBL_VARCHAR2000,
414: ln_item_desc_tbl PO_TBL_VARCHAR2000,
415: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
416: ln_market_price_tbl PO_TBL_NUMBER,
417: ln_un_number_id_tbl PO_TBL_NUMBER,
418: ln_hazard_class_id_tbl PO_TBL_NUMBER,
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
414: ln_item_desc_tbl PO_TBL_VARCHAR2000,
415: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
416: ln_market_price_tbl PO_TBL_NUMBER,
417: ln_un_number_id_tbl PO_TBL_NUMBER,
418: ln_hazard_class_id_tbl PO_TBL_NUMBER,
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
422: ln_template_id_tbl PO_TBL_NUMBER,
418: ln_hazard_class_id_tbl PO_TBL_NUMBER,
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
422: ln_template_id_tbl PO_TBL_NUMBER,
423: ln_category_id_tbl PO_TBL_NUMBER,
424: line_ref_index_tbl PO_TBL_NUMBER,
425:
426: -- attributes added for processing purpose
419: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
422: ln_template_id_tbl PO_TBL_NUMBER,
423: ln_category_id_tbl PO_TBL_NUMBER,
424: line_ref_index_tbl PO_TBL_NUMBER,
425:
426: -- attributes added for processing purpose
427: shipment_num_unique_tbl PO_TBL_VARCHAR1,
420: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
421: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
422: ln_template_id_tbl PO_TBL_NUMBER,
423: ln_category_id_tbl PO_TBL_NUMBER,
424: line_ref_index_tbl PO_TBL_NUMBER,
425:
426: -- attributes added for processing purpose
427: shipment_num_unique_tbl PO_TBL_VARCHAR1,
428: error_flag_tbl PO_TBL_VARCHAR1,
439: -- that the procedure fill_all_dists_attr is also changed to init
440: -- the table
441: TYPE distributions_rec_type IS RECORD
442: (
443: intf_dist_id_tbl PO_TBL_NUMBER,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
440: -- the table
441: TYPE distributions_rec_type IS RECORD
442: (
443: intf_dist_id_tbl PO_TBL_NUMBER,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
441: TYPE distributions_rec_type IS RECORD
442: (
443: intf_dist_id_tbl PO_TBL_NUMBER,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
442: (
443: intf_dist_id_tbl PO_TBL_NUMBER,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
450: deliver_to_loc_id_tbl PO_TBL_NUMBER,
443: intf_dist_id_tbl PO_TBL_NUMBER,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
450: deliver_to_loc_id_tbl PO_TBL_NUMBER,
451: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
444: intf_header_id_tbl PO_TBL_NUMBER,
445: intf_line_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
450: deliver_to_loc_id_tbl PO_TBL_NUMBER,
451: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
452: deliver_to_person_id_tbl PO_TBL_NUMBER,
446: intf_line_loc_id_tbl PO_TBL_NUMBER,
447: po_dist_id_tbl PO_TBL_NUMBER,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
450: deliver_to_loc_id_tbl PO_TBL_NUMBER,
451: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
452: deliver_to_person_id_tbl PO_TBL_NUMBER,
453: dest_type_tbl PO_TBL_VARCHAR30,
454: dest_type_code_tbl PO_TBL_VARCHAR30,
448: dist_num_tbl PO_TBL_NUMBER,
449: deliver_to_loc_tbl PO_TBL_VARCHAR100,
450: deliver_to_loc_id_tbl PO_TBL_NUMBER,
451: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
452: deliver_to_person_id_tbl PO_TBL_NUMBER,
453: dest_type_tbl PO_TBL_VARCHAR30,
454: dest_type_code_tbl PO_TBL_VARCHAR30,
455: dest_org_tbl PO_TBL_VARCHAR100,
456: dest_org_id_tbl PO_TBL_NUMBER,
452: deliver_to_person_id_tbl PO_TBL_NUMBER,
453: dest_type_tbl PO_TBL_VARCHAR30,
454: dest_type_code_tbl PO_TBL_VARCHAR30,
455: dest_org_tbl PO_TBL_VARCHAR100,
456: dest_org_id_tbl PO_TBL_NUMBER,
457: wip_entity_tbl PO_TBL_VARCHAR2000,
458: wip_entity_id_tbl PO_TBL_NUMBER,
459: wip_line_code_tbl PO_TBL_VARCHAR30,
460: wip_line_id_tbl PO_TBL_NUMBER,
454: dest_type_code_tbl PO_TBL_VARCHAR30,
455: dest_org_tbl PO_TBL_VARCHAR100,
456: dest_org_id_tbl PO_TBL_NUMBER,
457: wip_entity_tbl PO_TBL_VARCHAR2000,
458: wip_entity_id_tbl PO_TBL_NUMBER,
459: wip_line_code_tbl PO_TBL_VARCHAR30,
460: wip_line_id_tbl PO_TBL_NUMBER,
461: bom_resource_code_tbl PO_TBL_VARCHAR30,
462: bom_resource_id_tbl PO_TBL_NUMBER,
456: dest_org_id_tbl PO_TBL_NUMBER,
457: wip_entity_tbl PO_TBL_VARCHAR2000,
458: wip_entity_id_tbl PO_TBL_NUMBER,
459: wip_line_code_tbl PO_TBL_VARCHAR30,
460: wip_line_id_tbl PO_TBL_NUMBER,
461: bom_resource_code_tbl PO_TBL_VARCHAR30,
462: bom_resource_id_tbl PO_TBL_NUMBER,
463: charge_account_tbl PO_TBL_VARCHAR2000,
464: charge_account_id_tbl PO_TBL_NUMBER,
458: wip_entity_id_tbl PO_TBL_NUMBER,
459: wip_line_code_tbl PO_TBL_VARCHAR30,
460: wip_line_id_tbl PO_TBL_NUMBER,
461: bom_resource_code_tbl PO_TBL_VARCHAR30,
462: bom_resource_id_tbl PO_TBL_NUMBER,
463: charge_account_tbl PO_TBL_VARCHAR2000,
464: charge_account_id_tbl PO_TBL_NUMBER,
465: dest_charge_account_id_tbl PO_TBL_NUMBER,
466: project_accounting_context_tbl PO_TBL_VARCHAR30,
460: wip_line_id_tbl PO_TBL_NUMBER,
461: bom_resource_code_tbl PO_TBL_VARCHAR30,
462: bom_resource_id_tbl PO_TBL_NUMBER,
463: charge_account_tbl PO_TBL_VARCHAR2000,
464: charge_account_id_tbl PO_TBL_NUMBER,
465: dest_charge_account_id_tbl PO_TBL_NUMBER,
466: project_accounting_context_tbl PO_TBL_VARCHAR30,
467: award_num_tbl PO_TBL_VARCHAR30,
468: award_id_tbl PO_TBL_NUMBER,
461: bom_resource_code_tbl PO_TBL_VARCHAR30,
462: bom_resource_id_tbl PO_TBL_NUMBER,
463: charge_account_tbl PO_TBL_VARCHAR2000,
464: charge_account_id_tbl PO_TBL_NUMBER,
465: dest_charge_account_id_tbl PO_TBL_NUMBER,
466: project_accounting_context_tbl PO_TBL_VARCHAR30,
467: award_num_tbl PO_TBL_VARCHAR30,
468: award_id_tbl PO_TBL_NUMBER,
469: project_tbl PO_TBL_VARCHAR30,
464: charge_account_id_tbl PO_TBL_NUMBER,
465: dest_charge_account_id_tbl PO_TBL_NUMBER,
466: project_accounting_context_tbl PO_TBL_VARCHAR30,
467: award_num_tbl PO_TBL_VARCHAR30,
468: award_id_tbl PO_TBL_NUMBER,
469: project_tbl PO_TBL_VARCHAR30,
470: project_id_tbl PO_TBL_NUMBER,
471: task_tbl PO_TBL_VARCHAR30,
472: task_id_tbl PO_TBL_NUMBER,
466: project_accounting_context_tbl PO_TBL_VARCHAR30,
467: award_num_tbl PO_TBL_VARCHAR30,
468: award_id_tbl PO_TBL_NUMBER,
469: project_tbl PO_TBL_VARCHAR30,
470: project_id_tbl PO_TBL_NUMBER,
471: task_tbl PO_TBL_VARCHAR30,
472: task_id_tbl PO_TBL_NUMBER,
473: expenditure_tbl PO_TBL_VARCHAR100,
474: expenditure_type_tbl PO_TBL_VARCHAR30,
468: award_id_tbl PO_TBL_NUMBER,
469: project_tbl PO_TBL_VARCHAR30,
470: project_id_tbl PO_TBL_NUMBER,
471: task_tbl PO_TBL_VARCHAR30,
472: task_id_tbl PO_TBL_NUMBER,
473: expenditure_tbl PO_TBL_VARCHAR100,
474: expenditure_type_tbl PO_TBL_VARCHAR30,
475: expenditure_org_tbl PO_TBL_VARCHAR100,
476: expenditure_org_id_tbl PO_TBL_NUMBER,
472: task_id_tbl PO_TBL_NUMBER,
473: expenditure_tbl PO_TBL_VARCHAR100,
474: expenditure_type_tbl PO_TBL_VARCHAR30,
475: expenditure_org_tbl PO_TBL_VARCHAR100,
476: expenditure_org_id_tbl PO_TBL_NUMBER,
477: expenditure_item_date_tbl PO_TBL_DATE,
478: end_item_unit_number_tbl PO_TBL_VARCHAR30,
479: dest_context_tbl PO_TBL_VARCHAR30,
480: gl_encumbered_date_tbl PO_TBL_DATE,
478: end_item_unit_number_tbl PO_TBL_VARCHAR30,
479: dest_context_tbl PO_TBL_VARCHAR30,
480: gl_encumbered_date_tbl PO_TBL_DATE,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482: variance_account_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
479: dest_context_tbl PO_TBL_VARCHAR30,
480: gl_encumbered_date_tbl PO_TBL_DATE,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482: variance_account_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
480: gl_encumbered_date_tbl PO_TBL_DATE,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482: variance_account_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
481: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
482: variance_account_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
483: accrual_account_id_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
484: budget_account_id_tbl PO_TBL_NUMBER,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
492: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
485: dest_variance_account_id_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
492: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
493: recovery_rate_tbl PO_TBL_NUMBER,
486: dest_subinventory_tbl PO_TBL_VARCHAR30,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
492: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
493: recovery_rate_tbl PO_TBL_NUMBER,
494: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
487: amount_ordered_tbl PO_TBL_NUMBER,
488: quantity_ordered_tbl PO_TBL_NUMBER,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
492: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
493: recovery_rate_tbl PO_TBL_NUMBER,
494: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
495: account_segment1_tbl PO_TBL_VARCHAR30,
489: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
490: wip_operation_seq_num_tbl PO_TBL_NUMBER,
491: wip_resource_seq_num_tbl PO_TBL_NUMBER,
492: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
493: recovery_rate_tbl PO_TBL_NUMBER,
494: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
495: account_segment1_tbl PO_TBL_VARCHAR30,
496: account_segment2_tbl PO_TBL_VARCHAR30,
497: account_segment3_tbl PO_TBL_VARCHAR30,
538: dist_attribute14_tbl PO_TBL_VARCHAR2000,
539: dist_attribute15_tbl PO_TBL_VARCHAR2000,
540:
541: -- standard who columns
542: last_updated_by_tbl PO_TBL_NUMBER,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
540:
541: -- standard who columns
542: last_updated_by_tbl PO_TBL_NUMBER,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
542: last_updated_by_tbl PO_TBL_NUMBER,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
550: program_update_date_tbl PO_TBL_DATE,
543: last_update_date_tbl PO_TBL_DATE,
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
550: program_update_date_tbl PO_TBL_DATE,
551:
544: last_update_login_tbl PO_TBL_NUMBER,
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
550: program_update_date_tbl PO_TBL_DATE,
551:
552: -- attributes exist in txn table but not in interface table
545: creation_date_tbl PO_TBL_DATE,
546: created_by_tbl PO_TBL_NUMBER,
547: request_id_tbl PO_TBL_NUMBER,
548: program_application_id_tbl PO_TBL_NUMBER,
549: program_id_tbl PO_TBL_NUMBER,
550: program_update_date_tbl PO_TBL_DATE,
551:
552: -- attributes exist in txn table but not in interface table
553: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
550: program_update_date_tbl PO_TBL_DATE,
551:
552: -- attributes exist in txn table but not in interface table
553: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
554: award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
555:
556: -- attributes read from line location record
557: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
558: loc_line_loc_id_tbl PO_TBL_NUMBER,
553: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
554: award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
555:
556: -- attributes read from line location record
557: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
558: loc_line_loc_id_tbl PO_TBL_NUMBER,
559: loc_shipment_type_tbl PO_TBL_VARCHAR30,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
554: award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
555:
556: -- attributes read from line location record
557: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
558: loc_line_loc_id_tbl PO_TBL_NUMBER,
559: loc_shipment_type_tbl PO_TBL_VARCHAR30,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
556: -- attributes read from line location record
557: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
558: loc_line_loc_id_tbl PO_TBL_NUMBER,
559: loc_shipment_type_tbl PO_TBL_VARCHAR30,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
563: loc_promised_date_tbl PO_TBL_DATE,
564: loc_price_override_tbl PO_TBL_NUMBER,
560: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
563: loc_promised_date_tbl PO_TBL_DATE,
564: loc_price_override_tbl PO_TBL_NUMBER,
565: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
566: loc_attribute1_tbl PO_TBL_VARCHAR2000,
567: loc_attribute2_tbl PO_TBL_VARCHAR2000,
568: loc_attribute3_tbl PO_TBL_VARCHAR2000,
561: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
562: loc_need_by_date_tbl PO_TBL_DATE,
563: loc_promised_date_tbl PO_TBL_DATE,
564: loc_price_override_tbl PO_TBL_NUMBER,
565: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
566: loc_attribute1_tbl PO_TBL_VARCHAR2000,
567: loc_attribute2_tbl PO_TBL_VARCHAR2000,
568: loc_attribute3_tbl PO_TBL_VARCHAR2000,
569: loc_attribute4_tbl PO_TBL_VARCHAR2000,
581:
582: -- attributes read from line record
583: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
584: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
585: ln_item_id_tbl PO_TBL_NUMBER,
586: ln_category_id_tbl PO_TBL_NUMBER,
587: ln_line_type_id_tbl PO_TBL_NUMBER,
588: ln_po_line_id_tbl PO_TBL_NUMBER,
589: ln_attribute1_tbl PO_TBL_VARCHAR2000,
582: -- attributes read from line record
583: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
584: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
585: ln_item_id_tbl PO_TBL_NUMBER,
586: ln_category_id_tbl PO_TBL_NUMBER,
587: ln_line_type_id_tbl PO_TBL_NUMBER,
588: ln_po_line_id_tbl PO_TBL_NUMBER,
589: ln_attribute1_tbl PO_TBL_VARCHAR2000,
590: ln_attribute2_tbl PO_TBL_VARCHAR2000,
583: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
584: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
585: ln_item_id_tbl PO_TBL_NUMBER,
586: ln_category_id_tbl PO_TBL_NUMBER,
587: ln_line_type_id_tbl PO_TBL_NUMBER,
588: ln_po_line_id_tbl PO_TBL_NUMBER,
589: ln_attribute1_tbl PO_TBL_VARCHAR2000,
590: ln_attribute2_tbl PO_TBL_VARCHAR2000,
591: ln_attribute3_tbl PO_TBL_VARCHAR2000,
584: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
585: ln_item_id_tbl PO_TBL_NUMBER,
586: ln_category_id_tbl PO_TBL_NUMBER,
587: ln_line_type_id_tbl PO_TBL_NUMBER,
588: ln_po_line_id_tbl PO_TBL_NUMBER,
589: ln_attribute1_tbl PO_TBL_VARCHAR2000,
590: ln_attribute2_tbl PO_TBL_VARCHAR2000,
591: ln_attribute3_tbl PO_TBL_VARCHAR2000,
592: ln_attribute4_tbl PO_TBL_VARCHAR2000,
602: ln_attribute14_tbl PO_TBL_VARCHAR2000,
603: ln_attribute15_tbl PO_TBL_VARCHAR2000,
604:
605: -- attributes read from header record
606: draft_id_tbl PO_TBL_NUMBER,
607: hd_agent_id_tbl PO_TBL_NUMBER,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
603: ln_attribute15_tbl PO_TBL_VARCHAR2000,
604:
605: -- attributes read from header record
606: draft_id_tbl PO_TBL_NUMBER,
607: hd_agent_id_tbl PO_TBL_NUMBER,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
611: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
604:
605: -- attributes read from header record
606: draft_id_tbl PO_TBL_NUMBER,
607: hd_agent_id_tbl PO_TBL_NUMBER,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
611: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
612: hd_vendor_id_tbl PO_TBL_NUMBER,
606: draft_id_tbl PO_TBL_NUMBER,
607: hd_agent_id_tbl PO_TBL_NUMBER,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
611: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
612: hd_vendor_id_tbl PO_TBL_NUMBER,
613: hd_attribute1_tbl PO_TBL_VARCHAR2000,
614: hd_attribute2_tbl PO_TBL_VARCHAR2000,
608: hd_po_header_id_tbl PO_TBL_NUMBER,
609: hd_rate_date_tbl PO_TBL_DATE,
610: hd_rate_tbl PO_TBL_NUMBER,
611: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
612: hd_vendor_id_tbl PO_TBL_NUMBER,
613: hd_attribute1_tbl PO_TBL_VARCHAR2000,
614: hd_attribute2_tbl PO_TBL_VARCHAR2000,
615: hd_attribute3_tbl PO_TBL_VARCHAR2000,
616: hd_attribute4_tbl PO_TBL_VARCHAR2000,
626: hd_attribute14_tbl PO_TBL_VARCHAR2000,
627: hd_attribute15_tbl PO_TBL_VARCHAR2000,
628:
629: -- attributes added for processing
630: ship_to_ou_id_tbl PO_TBL_NUMBER,
631: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
632: item_status_tbl PO_TBL_VARCHAR1,
633: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
634: dist_num_unique_tbl PO_TBL_VARCHAR1,
627: hd_attribute15_tbl PO_TBL_VARCHAR2000,
628:
629: -- attributes added for processing
630: ship_to_ou_id_tbl PO_TBL_NUMBER,
631: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
632: item_status_tbl PO_TBL_VARCHAR1,
633: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
634: dist_num_unique_tbl PO_TBL_VARCHAR1,
635: error_flag_tbl PO_TBL_VARCHAR1,
643: -- that the procedure fill_all_price_diffs_attr is also changed to
644: -- init the table
645: TYPE price_diffs_rec_type IS RECORD
646: (
647: intf_price_diff_id_tbl PO_TBL_NUMBER,
648: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
649: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
644: -- init the table
645: TYPE price_diffs_rec_type IS RECORD
646: (
647: intf_price_diff_id_tbl PO_TBL_NUMBER,
648: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
649: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
645: TYPE price_diffs_rec_type IS RECORD
646: (
647: intf_price_diff_id_tbl PO_TBL_NUMBER,
648: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
649: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
646: (
647: intf_price_diff_id_tbl PO_TBL_NUMBER,
648: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
649: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
654: multiplier_tbl PO_TBL_NUMBER,
649: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
654: multiplier_tbl PO_TBL_NUMBER,
655: min_multiplier_tbl PO_TBL_NUMBER,
656: max_multiplier_tbl PO_TBL_NUMBER,
657:
650: price_diff_num_tbl PO_TBL_NUMBER,
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
654: multiplier_tbl PO_TBL_NUMBER,
655: min_multiplier_tbl PO_TBL_NUMBER,
656: max_multiplier_tbl PO_TBL_NUMBER,
657:
658: -- attribute read from line location
651: price_type_tbl PO_TBL_VARCHAR30,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
654: multiplier_tbl PO_TBL_NUMBER,
655: min_multiplier_tbl PO_TBL_NUMBER,
656: max_multiplier_tbl PO_TBL_NUMBER,
657:
658: -- attribute read from line location
659: loc_line_loc_id_tbl PO_TBL_NUMBER,
652: entity_type_tbl PO_TBL_VARCHAR30,
653: entity_id_tbl PO_TBL_NUMBER,
654: multiplier_tbl PO_TBL_NUMBER,
655: min_multiplier_tbl PO_TBL_NUMBER,
656: max_multiplier_tbl PO_TBL_NUMBER,
657:
658: -- attribute read from line location
659: loc_line_loc_id_tbl PO_TBL_NUMBER,
660:
655: min_multiplier_tbl PO_TBL_NUMBER,
656: max_multiplier_tbl PO_TBL_NUMBER,
657:
658: -- attribute read from line location
659: loc_line_loc_id_tbl PO_TBL_NUMBER,
660:
661: -- attributes read from line record
662: ln_po_line_id_tbl PO_TBL_NUMBER,
663:
658: -- attribute read from line location
659: loc_line_loc_id_tbl PO_TBL_NUMBER,
660:
661: -- attributes read from line record
662: ln_po_line_id_tbl PO_TBL_NUMBER,
663:
664: -- attributes read from header record
665: draft_id_tbl PO_TBL_NUMBER,
666: hd_style_id_tbl PO_TBL_NUMBER,
661: -- attributes read from line record
662: ln_po_line_id_tbl PO_TBL_NUMBER,
663:
664: -- attributes read from header record
665: draft_id_tbl PO_TBL_NUMBER,
666: hd_style_id_tbl PO_TBL_NUMBER,
667:
668: -- attributes added for processing
669: error_flag_tbl PO_TBL_VARCHAR1,
662: ln_po_line_id_tbl PO_TBL_NUMBER,
663:
664: -- attributes read from header record
665: draft_id_tbl PO_TBL_NUMBER,
666: hd_style_id_tbl PO_TBL_NUMBER,
667:
668: -- attributes added for processing
669: error_flag_tbl PO_TBL_VARCHAR1,
670: price_diff_num_unique_tbl PO_TBL_VARCHAR1,
679: -- init the table
680: TYPE attr_values_rec_type IS RECORD
681: (
682: -- attribute from attr_values table
683: intf_attr_values_id_tbl PO_TBL_NUMBER,
684: org_id_tbl PO_TBL_NUMBER,
685:
686: -- attributes from line record
687: ln_po_line_id_tbl PO_TBL_NUMBER,
680: TYPE attr_values_rec_type IS RECORD
681: (
682: -- attribute from attr_values table
683: intf_attr_values_id_tbl PO_TBL_NUMBER,
684: org_id_tbl PO_TBL_NUMBER,
685:
686: -- attributes from line record
687: ln_po_line_id_tbl PO_TBL_NUMBER,
688: ln_ip_category_id_tbl PO_TBL_NUMBER,
683: intf_attr_values_id_tbl PO_TBL_NUMBER,
684: org_id_tbl PO_TBL_NUMBER,
685:
686: -- attributes from line record
687: ln_po_line_id_tbl PO_TBL_NUMBER,
688: ln_ip_category_id_tbl PO_TBL_NUMBER,
689: ln_item_id_tbl PO_TBL_NUMBER,
690:
691: -- attribute from header record
684: org_id_tbl PO_TBL_NUMBER,
685:
686: -- attributes from line record
687: ln_po_line_id_tbl PO_TBL_NUMBER,
688: ln_ip_category_id_tbl PO_TBL_NUMBER,
689: ln_item_id_tbl PO_TBL_NUMBER,
690:
691: -- attribute from header record
692: draft_id_tbl PO_TBL_NUMBER,
685:
686: -- attributes from line record
687: ln_po_line_id_tbl PO_TBL_NUMBER,
688: ln_ip_category_id_tbl PO_TBL_NUMBER,
689: ln_item_id_tbl PO_TBL_NUMBER,
690:
691: -- attribute from header record
692: draft_id_tbl PO_TBL_NUMBER,
693:
688: ln_ip_category_id_tbl PO_TBL_NUMBER,
689: ln_item_id_tbl PO_TBL_NUMBER,
690:
691: -- attribute from header record
692: draft_id_tbl PO_TBL_NUMBER,
693:
694: -- attributes added for processing purpose
695: attribute_values_id_tbl PO_TBL_NUMBER,
696: source_tbl DBMS_SQL.VARCHAR2_TABLE,
691: -- attribute from header record
692: draft_id_tbl PO_TBL_NUMBER,
693:
694: -- attributes added for processing purpose
695: attribute_values_id_tbl PO_TBL_NUMBER,
696: source_tbl DBMS_SQL.VARCHAR2_TABLE,
697: error_flag_tbl PO_TBL_VARCHAR1,
698:
699: rec_count NUMBER
707: -- to init the table
708: TYPE attr_values_tlp_rec_type IS RECORD
709: (
710: -- attribute from attr_values table
711: intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
712: language_tbl PO_TBL_VARCHAR5,
713: org_id_tbl PO_TBL_NUMBER,
714:
715: -- attribute from line
709: (
710: -- attribute from attr_values table
711: intf_attr_values_tlp_id_tbl PO_TBL_NUMBER,
712: language_tbl PO_TBL_VARCHAR5,
713: org_id_tbl PO_TBL_NUMBER,
714:
715: -- attribute from line
716: ln_po_line_id_tbl PO_TBL_NUMBER,
717: ln_ip_category_id_tbl PO_TBL_NUMBER,
712: language_tbl PO_TBL_VARCHAR5,
713: org_id_tbl PO_TBL_NUMBER,
714:
715: -- attribute from line
716: ln_po_line_id_tbl PO_TBL_NUMBER,
717: ln_ip_category_id_tbl PO_TBL_NUMBER,
718: ln_item_id_tbl PO_TBL_NUMBER,
719: ln_item_desc_tbl PO_TBL_VARCHAR2000,
720:
713: org_id_tbl PO_TBL_NUMBER,
714:
715: -- attribute from line
716: ln_po_line_id_tbl PO_TBL_NUMBER,
717: ln_ip_category_id_tbl PO_TBL_NUMBER,
718: ln_item_id_tbl PO_TBL_NUMBER,
719: ln_item_desc_tbl PO_TBL_VARCHAR2000,
720:
721: -- attribute from headers
714:
715: -- attribute from line
716: ln_po_line_id_tbl PO_TBL_NUMBER,
717: ln_ip_category_id_tbl PO_TBL_NUMBER,
718: ln_item_id_tbl PO_TBL_NUMBER,
719: ln_item_desc_tbl PO_TBL_VARCHAR2000,
720:
721: -- attribute from headers
722: draft_id_tbl PO_TBL_NUMBER,
718: ln_item_id_tbl PO_TBL_NUMBER,
719: ln_item_desc_tbl PO_TBL_VARCHAR2000,
720:
721: -- attribute from headers
722: draft_id_tbl PO_TBL_NUMBER,
723:
724: -- attributes added for processing purpose
725: error_flag_tbl PO_TBL_VARCHAR1,
726: attribute_values_tlp_id_tbl PO_TBL_NUMBER,
722: draft_id_tbl PO_TBL_NUMBER,
723:
724: -- attributes added for processing purpose
725: error_flag_tbl PO_TBL_VARCHAR1,
726: attribute_values_tlp_id_tbl PO_TBL_NUMBER,
727: source_tbl DBMS_SQL.VARCHAR2_TABLE,
728:
729: rec_count NUMBER
730: