[Home] [Help]
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,
19: rate_type_tbl PO_TBL_VARCHAR30,
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,
19: rate_type_tbl PO_TBL_VARCHAR30,
20: rate_type_code_tbl PO_TBL_VARCHAR30,
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,
19: rate_type_tbl PO_TBL_VARCHAR30,
20: rate_type_code_tbl PO_TBL_VARCHAR30,
21: rate_date_tbl PO_TBL_DATE,
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,
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,
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,
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,
16: document_num_tbl PO_TBL_VARCHAR30,
17: doc_type_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,
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,
35: vendor_site_id_tbl PO_TBL_NUMBER,
36: vendor_contact_tbl PO_TBL_VARCHAR2000,
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,
38: from_rfq_num_tbl PO_TBL_VARCHAR30,
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,
42: freight_term_tbl PO_TBL_VARCHAR30,
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,
44: shipping_control_tbl PO_TBL_VARCHAR30,
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,
44: shipping_control_tbl PO_TBL_VARCHAR30,
45: currency_code_tbl PO_TBL_VARCHAR30,
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,
44: shipping_control_tbl PO_TBL_VARCHAR30,
45: currency_code_tbl PO_TBL_VARCHAR30,
46: quote_warning_delay_tbl PO_TBL_NUMBER,
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,
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,
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,
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,
41: freight_carrier_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,
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,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
52: revision_num_tbl PO_TBL_NUMBER,
53: confirming_order_flag_tbl PO_TBL_VARCHAR1,
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,
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,
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,
60: vendor_doc_num_tbl PO_TBL_VARCHAR30,
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,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
64: effective_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,
78: budget_account_tbl PO_TBL_VARCHAR2000,
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,
78: budget_account_tbl PO_TBL_VARCHAR2000,
79: budget_account_segment1_tbl PO_TBL_VARCHAR30,
80: budget_account_segment2_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,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
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,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_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,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
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,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
79: budget_account_segment1_tbl PO_TBL_VARCHAR30,
80: budget_account_segment2_tbl PO_TBL_VARCHAR30,
81: budget_account_segment3_tbl PO_TBL_VARCHAR30,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
80: budget_account_segment2_tbl PO_TBL_VARCHAR30,
81: budget_account_segment3_tbl PO_TBL_VARCHAR30,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
81: budget_account_segment3_tbl PO_TBL_VARCHAR30,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
82: budget_account_segment4_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
83: budget_account_segment5_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
84: budget_account_segment6_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
85: budget_account_segment7_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
86: budget_account_segment8_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
87: budget_account_segment9_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
88: budget_account_segment10_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
89: budget_account_segment11_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
90: budget_account_segment12_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
91: budget_account_segment13_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
92: budget_account_segment14_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
93: budget_account_segment15_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
94: budget_account_segment16_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
95: budget_account_segment17_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
96: budget_account_segment18_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
97: budget_account_segment19_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_tbl PO_TBL_VARCHAR30,
98: budget_account_segment20_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_tbl PO_TBL_VARCHAR30,
106: budget_account_segment28_tbl PO_TBL_VARCHAR30,
99: budget_account_segment21_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_tbl PO_TBL_VARCHAR30,
106: budget_account_segment28_tbl PO_TBL_VARCHAR30,
107: budget_account_segment29_tbl PO_TBL_VARCHAR30,
100: budget_account_segment22_tbl PO_TBL_VARCHAR30,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_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,
101: budget_account_segment23_tbl PO_TBL_VARCHAR30,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_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,
102: budget_account_segment24_tbl PO_TBL_VARCHAR30,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_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,
103: budget_account_segment25_tbl PO_TBL_VARCHAR30,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_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,
104: budget_account_segment26_tbl PO_TBL_VARCHAR30,
105: budget_account_segment27_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,
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,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
128: vendor_order_num_tbl PO_TBL_VARCHAR30,
129: quote_vendor_quote_num_tbl PO_TBL_VARCHAR30,
130: doc_creation_method_tbl PO_TBL_VARCHAR30,
124:
125: -- attributes not read from interface table but exist in txn table
126: status_lookup_code_tbl PO_TBL_VARCHAR30,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
128: vendor_order_num_tbl PO_TBL_VARCHAR30,
129: quote_vendor_quote_num_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,
125: -- attributes not read from interface table but exist in txn table
126: status_lookup_code_tbl PO_TBL_VARCHAR30,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
128: vendor_order_num_tbl PO_TBL_VARCHAR30,
129: quote_vendor_quote_num_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,
126: status_lookup_code_tbl PO_TBL_VARCHAR30,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
128: vendor_order_num_tbl PO_TBL_VARCHAR30,
129: quote_vendor_quote_num_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,
127: cancel_flag_tbl PO_TBL_VARCHAR1,
128: vendor_order_num_tbl PO_TBL_VARCHAR30,
129: quote_vendor_quote_num_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:
129: quote_vendor_quote_num_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,
140:
141: --attributes added for CLM PDOI Integration
142: clm_document_format_tbl PO_TBL_VARCHAR2000,
143: clm_standard_form_tbl PO_TBL_VARCHAR2000,
144: clm_award_type_tbl PO_TBL_VARCHAR30,
145: clm_source_document_id_tbl PO_TBL_NUMBER,
146: clm_external_idv_tbl PO_TBL_VARCHAR2000,
147: clm_vendor_offer_number_tbl PO_TBL_VARCHAR2000,
148: clm_award_administrator_tbl PO_TBL_VARCHAR2000,
162: clm_award_admin_disp_tbl PO_TBL_VARCHAR240,
163: clm_contract_officer_disp_tbl PO_TBL_VARCHAR240,
164: clm_contract_officer_tbl PO_TBL_NUMBER,
165: clm_source_document_disp_tbl PO_TBL_VARCHAR240,
166: draft_type_tbl PO_TBL_VARCHAR30
167:
168:
169: -- ATTENTION: If you are adding new attributes to this record type, see
170: -- the message above first.
182: intf_line_id_tbl PO_TBL_NUMBER,
183: intf_header_id_tbl PO_TBL_NUMBER,
184: po_header_id_tbl PO_TBL_NUMBER,
185: po_line_id_tbl PO_TBL_NUMBER,
186: action_tbl PO_TBL_VARCHAR30,
187: document_num_tbl PO_TBL_VARCHAR30,
188: item_tbl PO_TBL_VARCHAR2000,
189: vendor_product_num_tbl PO_TBL_VARCHAR30,
190: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
183: intf_header_id_tbl PO_TBL_NUMBER,
184: po_header_id_tbl PO_TBL_NUMBER,
185: po_line_id_tbl PO_TBL_NUMBER,
186: action_tbl PO_TBL_VARCHAR30,
187: document_num_tbl PO_TBL_VARCHAR30,
188: item_tbl PO_TBL_VARCHAR2000,
189: vendor_product_num_tbl PO_TBL_VARCHAR30,
190: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
191: item_id_tbl PO_TBL_NUMBER,
185: po_line_id_tbl PO_TBL_NUMBER,
186: action_tbl PO_TBL_VARCHAR30,
187: document_num_tbl PO_TBL_VARCHAR30,
188: item_tbl PO_TBL_VARCHAR2000,
189: vendor_product_num_tbl PO_TBL_VARCHAR30,
190: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
191: item_id_tbl PO_TBL_NUMBER,
192: item_revision_tbl PO_TBL_VARCHAR5,
193: job_business_group_name_tbl PO_TBL_VARCHAR2000,
198: category_id_tbl PO_TBL_NUMBER,
199: ip_category_tbl PO_TBL_VARCHAR2000,
200: ip_category_id_tbl PO_TBL_NUMBER,
201: uom_code_tbl PO_TBL_VARCHAR5,
202: unit_of_measure_tbl PO_TBL_VARCHAR30,
203: line_type_tbl PO_TBL_VARCHAR30,
204: line_type_id_tbl PO_TBL_NUMBER,
205: un_number_tbl PO_TBL_VARCHAR30,
206: un_number_id_tbl PO_TBL_NUMBER,
199: ip_category_tbl PO_TBL_VARCHAR2000,
200: ip_category_id_tbl PO_TBL_NUMBER,
201: uom_code_tbl PO_TBL_VARCHAR5,
202: unit_of_measure_tbl PO_TBL_VARCHAR30,
203: line_type_tbl PO_TBL_VARCHAR30,
204: line_type_id_tbl PO_TBL_NUMBER,
205: un_number_tbl PO_TBL_VARCHAR30,
206: un_number_id_tbl PO_TBL_NUMBER,
207: hazard_class_tbl PO_TBL_VARCHAR100,
201: uom_code_tbl PO_TBL_VARCHAR5,
202: unit_of_measure_tbl PO_TBL_VARCHAR30,
203: line_type_tbl PO_TBL_VARCHAR30,
204: line_type_id_tbl PO_TBL_NUMBER,
205: un_number_tbl PO_TBL_VARCHAR30,
206: un_number_id_tbl PO_TBL_NUMBER,
207: hazard_class_tbl PO_TBL_VARCHAR100,
208: hazard_class_id_tbl PO_TBL_NUMBER,
209: template_name_tbl PO_TBL_VARCHAR30,
205: un_number_tbl PO_TBL_VARCHAR30,
206: un_number_id_tbl PO_TBL_NUMBER,
207: hazard_class_tbl PO_TBL_VARCHAR100,
208: hazard_class_id_tbl PO_TBL_NUMBER,
209: template_name_tbl PO_TBL_VARCHAR30,
210: template_id_tbl PO_TBL_NUMBER,
211: item_desc_tbl PO_TBL_VARCHAR2000,
212: unit_price_tbl PO_TBL_NUMBER,
213: base_unit_price_tbl PO_TBL_NUMBER,
217: market_price_tbl PO_TBL_NUMBER,
218: capital_expense_flag_tbl PO_TBL_VARCHAR1,
219: min_release_amount_tbl PO_TBL_NUMBER,
220: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
221: price_type_tbl PO_TBL_VARCHAR30,
222: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
223: closed_code_tbl PO_TBL_VARCHAR30,
224: quantity_tbl PO_TBL_NUMBER,
225: line_num_tbl PO_TBL_NUMBER,
218: capital_expense_flag_tbl PO_TBL_VARCHAR1,
219: min_release_amount_tbl PO_TBL_NUMBER,
220: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
221: price_type_tbl PO_TBL_VARCHAR30,
222: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
223: closed_code_tbl PO_TBL_VARCHAR30,
224: quantity_tbl PO_TBL_NUMBER,
225: line_num_tbl PO_TBL_NUMBER,
226: shipment_num_tbl PO_TBL_NUMBER,
219: min_release_amount_tbl PO_TBL_NUMBER,
220: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
221: price_type_tbl PO_TBL_VARCHAR30,
222: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
223: closed_code_tbl PO_TBL_VARCHAR30,
224: quantity_tbl PO_TBL_NUMBER,
225: line_num_tbl PO_TBL_NUMBER,
226: shipment_num_tbl PO_TBL_NUMBER,
227: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
240: negotiated_flag_tbl PO_TBL_VARCHAR1,
241: amount_tbl PO_TBL_NUMBER,
242: contractor_last_name_tbl PO_TBL_VARCHAR2000,
243: contractor_first_name_tbl PO_TBL_VARCHAR2000,
244: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
245: not_to_exceed_price_tbl PO_TBL_NUMBER,
246: po_release_id_tbl PO_TBL_NUMBER,
247: release_num_tbl PO_TBL_NUMBER,
248: source_shipment_id_tbl PO_TBL_NUMBER,
245: not_to_exceed_price_tbl PO_TBL_NUMBER,
246: po_release_id_tbl PO_TBL_NUMBER,
247: release_num_tbl PO_TBL_NUMBER,
248: source_shipment_id_tbl PO_TBL_NUMBER,
249: contract_num_tbl PO_TBL_VARCHAR30,
250: contract_id_tbl PO_TBL_NUMBER,
251: type_1099_tbl PO_TBL_VARCHAR30,
252: closed_by_tbl PO_TBL_NUMBER,
253: closed_date_tbl PO_TBL_DATE,
247: release_num_tbl PO_TBL_NUMBER,
248: source_shipment_id_tbl PO_TBL_NUMBER,
249: contract_num_tbl PO_TBL_VARCHAR30,
250: contract_id_tbl PO_TBL_NUMBER,
251: type_1099_tbl PO_TBL_VARCHAR30,
252: closed_by_tbl PO_TBL_NUMBER,
253: closed_date_tbl PO_TBL_DATE,
254: committed_amount_tbl PO_TBL_NUMBER,
255: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
251: type_1099_tbl PO_TBL_VARCHAR30,
252: closed_by_tbl PO_TBL_NUMBER,
253: closed_date_tbl PO_TBL_DATE,
254: committed_amount_tbl PO_TBL_NUMBER,
255: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
256: weight_uom_code_tbl PO_TBL_VARCHAR5,
257: volume_uom_code_tbl PO_TBL_VARCHAR5,
258: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
259: secondary_quantity_tbl PO_TBL_NUMBER,
254: committed_amount_tbl PO_TBL_NUMBER,
255: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
256: weight_uom_code_tbl PO_TBL_VARCHAR5,
257: volume_uom_code_tbl PO_TBL_VARCHAR5,
258: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
259: secondary_quantity_tbl PO_TBL_NUMBER,
260: preferred_grade_tbl PO_TBL_VARCHAR2000,
261: process_code_tbl PO_TBL_VARCHAR30,
262: parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
257: volume_uom_code_tbl PO_TBL_VARCHAR5,
258: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
259: secondary_quantity_tbl PO_TBL_NUMBER,
260: preferred_grade_tbl PO_TBL_VARCHAR2000,
261: process_code_tbl PO_TBL_VARCHAR30,
262: parent_interface_line_id_tbl PO_TBL_NUMBER, -- bug5149827
263: file_line_language_tbl PO_TBL_VARCHAR5, -- bug 5489942
264:
265: -- standard who columns
273: program_id_tbl PO_TBL_NUMBER,
274: program_update_date_tbl PO_TBL_DATE,
275:
276: -- attributes that are in line txn table but not in interface table
277: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
278: purchase_basis_tbl PO_TBL_VARCHAR30,
279: matching_basis_tbl PO_TBL_VARCHAR30,
280: unordered_flag_tbl PO_TBL_VARCHAR1,
281: cancel_flag_tbl PO_TBL_VARCHAR1,
274: program_update_date_tbl PO_TBL_DATE,
275:
276: -- attributes that are in line txn table but not in interface table
277: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
278: purchase_basis_tbl PO_TBL_VARCHAR30,
279: matching_basis_tbl PO_TBL_VARCHAR30,
280: unordered_flag_tbl PO_TBL_VARCHAR1,
281: cancel_flag_tbl PO_TBL_VARCHAR1,
282: quantity_committed_tbl PO_TBL_NUMBER,
275:
276: -- attributes that are in line txn table but not in interface table
277: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
278: purchase_basis_tbl PO_TBL_VARCHAR30,
279: matching_basis_tbl PO_TBL_VARCHAR30,
280: unordered_flag_tbl PO_TBL_VARCHAR1,
281: cancel_flag_tbl PO_TBL_VARCHAR1,
282: quantity_committed_tbl PO_TBL_NUMBER,
283: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
279: matching_basis_tbl PO_TBL_VARCHAR30,
280: unordered_flag_tbl PO_TBL_VARCHAR1,
281: cancel_flag_tbl PO_TBL_VARCHAR1,
282: quantity_committed_tbl PO_TBL_NUMBER,
283: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
284:
285: -- attributes read from the header interface record
286: draft_id_tbl PO_TBL_NUMBER,
287: hd_action_tbl PO_TBL_VARCHAR30,
283: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
284:
285: -- attributes read from the header interface record
286: draft_id_tbl PO_TBL_NUMBER,
287: hd_action_tbl PO_TBL_VARCHAR30,
288: hd_po_header_id_tbl PO_TBL_NUMBER,
289: hd_vendor_id_tbl PO_TBL_NUMBER,
290: hd_min_release_amount_tbl PO_TBL_NUMBER,
291: hd_start_date_tbl PO_TBL_DATE,
290: hd_min_release_amount_tbl PO_TBL_NUMBER,
291: hd_start_date_tbl PO_TBL_DATE,
292: hd_end_date_tbl PO_TBL_DATE,
293: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
294: hd_currency_code_tbl PO_TBL_VARCHAR30,
295: hd_created_language_tbl PO_TBL_VARCHAR5,
296: hd_style_id_tbl PO_TBL_NUMBER,
297: hd_rate_type_tbl PO_TBL_VARCHAR30,
298: hd_rate_tbl PO_TBL_NUMBER, -- bug 9194215
293: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
294: hd_currency_code_tbl PO_TBL_VARCHAR30,
295: hd_created_language_tbl PO_TBL_VARCHAR5,
296: hd_style_id_tbl PO_TBL_NUMBER,
297: hd_rate_type_tbl PO_TBL_VARCHAR30,
298: hd_rate_tbl PO_TBL_NUMBER, -- bug 9194215
299:
300: -- attributes added for location processing
301: create_line_loc_tbl PO_TBL_VARCHAR1,
316: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
317:
318: --attributes added for pdoi clm integration project
319: contract_type_tbl PO_TBL_VARCHAR240,
320: cost_constraint_tbl PO_TBL_VARCHAR30,
321: note_to_vendor_tbl PO_TBL_VARCHAR2000,
322: oke_contract_version_id_tbl PO_TBL_NUMBER,
323: oke_contract_header_id_tbl PO_TBL_VARCHAR240,
324: clm_option_indicator_tbl PO_TBL_VARCHAR1,
328: clm_option_to_date_tbl PO_TBL_DATE,
329: clm_idc_type_tbl PO_TBL_VARCHAR240,
330: line_num_display_tbl PO_TBL_VARCHAR100,
331: clm_funded_flag_tbl PO_TBL_VARCHAR1,
332: user_document_status_tbl PO_TBL_VARCHAR30,
333: clm_exercised_flag_tbl PO_TBL_VARCHAR1,
334: clm_exercised_date_tbl PO_TBL_DATE,
335: clm_min_total_amount_tbl PO_TBL_NUMBER,
336: clm_max_total_amount_tbl PO_TBL_NUMBER,
367: intf_line_loc_id_tbl PO_TBL_NUMBER,
368: intf_line_id_tbl PO_TBL_NUMBER,
369: intf_header_id_tbl PO_TBL_NUMBER,
370: shipment_num_tbl PO_TBL_NUMBER,
371: shipment_type_tbl PO_TBL_VARCHAR30,
372: line_loc_id_tbl PO_TBL_NUMBER,
373: ship_to_org_code_tbl PO_TBL_VARCHAR5,
374: ship_to_org_id_tbl PO_TBL_NUMBER,
375: ship_to_loc_tbl PO_TBL_VARCHAR100,
375: ship_to_loc_tbl PO_TBL_VARCHAR100,
376: ship_to_loc_id_tbl PO_TBL_NUMBER,
377: payment_terms_tbl PO_TBL_VARCHAR100,
378: terms_id_tbl PO_TBL_NUMBER,
379: receiving_routing_tbl PO_TBL_VARCHAR30,
380: receiving_routing_id_tbl PO_TBL_NUMBER,
381: inspection_required_flag_tbl PO_TBL_VARCHAR1,
382: receipt_required_flag_tbl PO_TBL_VARCHAR1,
383: price_override_tbl PO_TBL_NUMBER,
381: inspection_required_flag_tbl PO_TBL_VARCHAR1,
382: receipt_required_flag_tbl PO_TBL_VARCHAR1,
383: price_override_tbl PO_TBL_NUMBER,
384: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
385: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
386: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
387: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
388: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
389: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
382: receipt_required_flag_tbl PO_TBL_VARCHAR1,
383: price_override_tbl PO_TBL_NUMBER,
384: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
385: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
386: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
387: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
388: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
389: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
390: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
386: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
387: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
388: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
389: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
390: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
391: invoice_close_tolerance_tbl PO_TBL_NUMBER,
392: receive_close_tolerance_tbl PO_TBL_NUMBER,
393: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394: firm_flag_tbl PO_TBL_VARCHAR30,
390: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
391: invoice_close_tolerance_tbl PO_TBL_NUMBER,
392: receive_close_tolerance_tbl PO_TBL_NUMBER,
393: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394: firm_flag_tbl PO_TBL_VARCHAR30,
395: fob_tbl PO_TBL_VARCHAR30,
396: freight_carrier_tbl PO_TBL_VARCHAR30,
397: freight_term_tbl PO_TBL_VARCHAR30,
398: need_by_date_tbl PO_TBL_DATE,
391: invoice_close_tolerance_tbl PO_TBL_NUMBER,
392: receive_close_tolerance_tbl PO_TBL_NUMBER,
393: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394: firm_flag_tbl PO_TBL_VARCHAR30,
395: fob_tbl PO_TBL_VARCHAR30,
396: freight_carrier_tbl PO_TBL_VARCHAR30,
397: freight_term_tbl PO_TBL_VARCHAR30,
398: need_by_date_tbl PO_TBL_DATE,
399: promised_date_tbl PO_TBL_DATE,
392: receive_close_tolerance_tbl PO_TBL_NUMBER,
393: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394: firm_flag_tbl PO_TBL_VARCHAR30,
395: fob_tbl PO_TBL_VARCHAR30,
396: freight_carrier_tbl PO_TBL_VARCHAR30,
397: freight_term_tbl PO_TBL_VARCHAR30,
398: need_by_date_tbl PO_TBL_DATE,
399: promised_date_tbl PO_TBL_DATE,
400: quantity_tbl PO_TBL_NUMBER,
393: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
394: firm_flag_tbl PO_TBL_VARCHAR30,
395: fob_tbl PO_TBL_VARCHAR30,
396: freight_carrier_tbl PO_TBL_VARCHAR30,
397: freight_term_tbl PO_TBL_VARCHAR30,
398: need_by_date_tbl PO_TBL_DATE,
399: promised_date_tbl PO_TBL_DATE,
400: quantity_tbl PO_TBL_NUMBER,
401: amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
402: start_date_tbl PO_TBL_DATE,
403: end_date_tbl PO_TBL_DATE,
404: note_to_receiver_tbl PO_TBL_VARCHAR2000,
405: price_discount_tbl PO_TBL_NUMBER,
406: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
407: secondary_quantity_tbl PO_TBL_NUMBER,
408: preferred_grade_tbl PO_TBL_VARCHAR2000,
409: tax_code_id_tbl PO_TBL_NUMBER,
410: tax_name_tbl PO_TBL_VARCHAR30,
406: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
407: secondary_quantity_tbl PO_TBL_NUMBER,
408: preferred_grade_tbl PO_TBL_VARCHAR2000,
409: tax_code_id_tbl PO_TBL_NUMBER,
410: tax_name_tbl PO_TBL_VARCHAR30,
411: taxable_flag_tbl PO_TBL_VARCHAR1,
412: unit_of_measure_tbl PO_TBL_VARCHAR30,
413: value_basis_tbl PO_TBL_VARCHAR30,
414: matching_basis_tbl PO_TBL_VARCHAR30,
408: preferred_grade_tbl PO_TBL_VARCHAR2000,
409: tax_code_id_tbl PO_TBL_NUMBER,
410: tax_name_tbl PO_TBL_VARCHAR30,
411: taxable_flag_tbl PO_TBL_VARCHAR1,
412: unit_of_measure_tbl PO_TBL_VARCHAR30,
413: value_basis_tbl PO_TBL_VARCHAR30,
414: matching_basis_tbl PO_TBL_VARCHAR30,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
409: tax_code_id_tbl PO_TBL_NUMBER,
410: tax_name_tbl PO_TBL_VARCHAR30,
411: taxable_flag_tbl PO_TBL_VARCHAR1,
412: unit_of_measure_tbl PO_TBL_VARCHAR30,
413: value_basis_tbl PO_TBL_VARCHAR30,
414: matching_basis_tbl PO_TBL_VARCHAR30,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
417: -- attributes in txn table but not in interface table
410: tax_name_tbl PO_TBL_VARCHAR30,
411: taxable_flag_tbl PO_TBL_VARCHAR1,
412: unit_of_measure_tbl PO_TBL_VARCHAR30,
413: value_basis_tbl PO_TBL_VARCHAR30,
414: matching_basis_tbl PO_TBL_VARCHAR30,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
417: -- attributes in txn table but not in interface table
418: match_option_tbl PO_TBL_VARCHAR30,
411: taxable_flag_tbl PO_TBL_VARCHAR1,
412: unit_of_measure_tbl PO_TBL_VARCHAR30,
413: value_basis_tbl PO_TBL_VARCHAR30,
414: matching_basis_tbl PO_TBL_VARCHAR30,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
417: -- attributes in txn table but not in interface table
418: match_option_tbl PO_TBL_VARCHAR30,
419: txn_flow_header_id_tbl PO_TBL_NUMBER,
414: matching_basis_tbl PO_TBL_VARCHAR30,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
416:
417: -- attributes in txn table but not in interface table
418: match_option_tbl PO_TBL_VARCHAR30,
419: txn_flow_header_id_tbl PO_TBL_NUMBER,
420: outsourced_assembly_tbl PO_TBL_NUMBER,
421: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
422:
417: -- attributes in txn table but not in interface table
418: match_option_tbl PO_TBL_VARCHAR30,
419: txn_flow_header_id_tbl PO_TBL_NUMBER,
420: outsourced_assembly_tbl PO_TBL_NUMBER,
421: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
422:
423: -- standard who columns
424: last_updated_by_tbl PO_TBL_NUMBER,
425: last_update_date_tbl PO_TBL_DATE,
438: --< Shared Proc 14223789 Start >
439: ln_item_category_id_tbl PO_TBL_NUMBER,
440: --< Shared Proc 14223789 End >
441:
442: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
443: ln_action_tbl PO_TBL_VARCHAR30,
444: ln_unit_price_tbl PO_TBL_NUMBER,
445: ln_quantity_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
446: ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
439: ln_item_category_id_tbl PO_TBL_NUMBER,
440: --< Shared Proc 14223789 End >
441:
442: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
443: ln_action_tbl PO_TBL_VARCHAR30,
444: ln_unit_price_tbl PO_TBL_NUMBER,
445: ln_quantity_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
446: ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
447: ln_line_type_id_tbl PO_TBL_NUMBER,
444: ln_unit_price_tbl PO_TBL_NUMBER,
445: ln_quantity_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
446: ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
447: ln_line_type_id_tbl PO_TBL_NUMBER,
448: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
449: ln_closed_code_tbl PO_TBL_VARCHAR30,
450: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451: ln_matching_basis_tbl PO_TBL_VARCHAR30,
452: ln_item_revision_tbl PO_TBL_VARCHAR5,
445: ln_quantity_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
446: ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
447: ln_line_type_id_tbl PO_TBL_NUMBER,
448: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
449: ln_closed_code_tbl PO_TBL_VARCHAR30,
450: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451: ln_matching_basis_tbl PO_TBL_VARCHAR30,
452: ln_item_revision_tbl PO_TBL_VARCHAR5,
453: ln_expiration_date_tbl PO_TBL_DATE,
446: ln_amount_tbl PO_TBL_NUMBER, -- PDOI for Complex PO Project
447: ln_line_type_id_tbl PO_TBL_NUMBER,
448: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
449: ln_closed_code_tbl PO_TBL_VARCHAR30,
450: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451: ln_matching_basis_tbl PO_TBL_VARCHAR30,
452: ln_item_revision_tbl PO_TBL_VARCHAR5,
453: ln_expiration_date_tbl PO_TBL_DATE,
454: ln_government_context_tbl PO_TBL_VARCHAR30,
447: ln_line_type_id_tbl PO_TBL_NUMBER,
448: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
449: ln_closed_code_tbl PO_TBL_VARCHAR30,
450: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451: ln_matching_basis_tbl PO_TBL_VARCHAR30,
452: ln_item_revision_tbl PO_TBL_VARCHAR5,
453: ln_expiration_date_tbl PO_TBL_DATE,
454: ln_government_context_tbl PO_TBL_VARCHAR30,
455: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
450: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
451: ln_matching_basis_tbl PO_TBL_VARCHAR30,
452: ln_item_revision_tbl PO_TBL_VARCHAR5,
453: ln_expiration_date_tbl PO_TBL_DATE,
454: ln_government_context_tbl PO_TBL_VARCHAR30,
455: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
456: ln_closed_date_tbl PO_TBL_DATE,
457: ln_closed_by_tbl PO_TBL_NUMBER,
458: ln_from_header_id_tbl PO_TBL_NUMBER,
456: ln_closed_date_tbl PO_TBL_DATE,
457: ln_closed_by_tbl PO_TBL_NUMBER,
458: ln_from_header_id_tbl PO_TBL_NUMBER,
459: ln_from_line_id_tbl PO_TBL_NUMBER,
460: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30, -- bug5016163
461:
462: -- attributes read from the header interface record
463: draft_id_tbl PO_TBL_NUMBER,
464: hd_po_header_id_tbl PO_TBL_NUMBER,
462: -- attributes read from the header interface record
463: draft_id_tbl PO_TBL_NUMBER,
464: hd_po_header_id_tbl PO_TBL_NUMBER,
465: --< Shared Proc 14223789 Start>
466: hd_doc_type_tbl PO_TBL_VARCHAR30,
467: --< Shared Proc 14223789 End>
468: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
469: hd_vendor_id_tbl PO_TBL_NUMBER,
470: hd_vendor_site_id_tbl PO_TBL_NUMBER,
468: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
469: hd_vendor_id_tbl PO_TBL_NUMBER,
470: hd_vendor_site_id_tbl PO_TBL_NUMBER,
471: hd_terms_id_tbl PO_TBL_NUMBER,
472: hd_fob_tbl PO_TBL_VARCHAR30,
473: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
474: hd_freight_term_tbl PO_TBL_VARCHAR30,
475: hd_approved_flag_tbl PO_TBL_VARCHAR1,
476: hd_effective_date_tbl PO_TBL_DATE,
469: hd_vendor_id_tbl PO_TBL_NUMBER,
470: hd_vendor_site_id_tbl PO_TBL_NUMBER,
471: hd_terms_id_tbl PO_TBL_NUMBER,
472: hd_fob_tbl PO_TBL_VARCHAR30,
473: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
474: hd_freight_term_tbl PO_TBL_VARCHAR30,
475: hd_approved_flag_tbl PO_TBL_VARCHAR1,
476: hd_effective_date_tbl PO_TBL_DATE,
477: hd_expiration_date_tbl PO_TBL_DATE,
470: hd_vendor_site_id_tbl PO_TBL_NUMBER,
471: hd_terms_id_tbl PO_TBL_NUMBER,
472: hd_fob_tbl PO_TBL_VARCHAR30,
473: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
474: hd_freight_term_tbl PO_TBL_VARCHAR30,
475: hd_approved_flag_tbl PO_TBL_VARCHAR1,
476: hd_effective_date_tbl PO_TBL_DATE,
477: hd_expiration_date_tbl PO_TBL_DATE,
478: hd_style_id_tbl PO_TBL_NUMBER,
475: hd_approved_flag_tbl PO_TBL_VARCHAR1,
476: hd_effective_date_tbl PO_TBL_DATE,
477: hd_expiration_date_tbl PO_TBL_DATE,
478: hd_style_id_tbl PO_TBL_NUMBER,
479: hd_currency_code_tbl PO_TBL_VARCHAR30, -- 9294987 bug
480:
481: -- attributes added for item processing(read from line)
482: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,
483: ln_unit_weight_tbl PO_TBL_NUMBER,
503: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
504: ln_market_price_tbl PO_TBL_NUMBER,
505: ln_un_number_id_tbl PO_TBL_NUMBER,
506: ln_hazard_class_id_tbl PO_TBL_NUMBER,
507: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
508: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
509: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
510: ln_template_id_tbl PO_TBL_NUMBER,
511: ln_category_id_tbl PO_TBL_NUMBER,
538: deliver_to_loc_tbl PO_TBL_VARCHAR100,
539: deliver_to_loc_id_tbl PO_TBL_NUMBER,
540: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
541: deliver_to_person_id_tbl PO_TBL_NUMBER,
542: dest_type_tbl PO_TBL_VARCHAR30,
543: dest_type_code_tbl PO_TBL_VARCHAR30,
544: dest_org_tbl PO_TBL_VARCHAR100,
545: dest_org_id_tbl PO_TBL_NUMBER,
546: wip_entity_tbl PO_TBL_VARCHAR2000,
539: deliver_to_loc_id_tbl PO_TBL_NUMBER,
540: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
541: deliver_to_person_id_tbl PO_TBL_NUMBER,
542: dest_type_tbl PO_TBL_VARCHAR30,
543: dest_type_code_tbl PO_TBL_VARCHAR30,
544: dest_org_tbl PO_TBL_VARCHAR100,
545: dest_org_id_tbl PO_TBL_NUMBER,
546: wip_entity_tbl PO_TBL_VARCHAR2000,
547: wip_entity_id_tbl PO_TBL_NUMBER,
544: dest_org_tbl PO_TBL_VARCHAR100,
545: dest_org_id_tbl PO_TBL_NUMBER,
546: wip_entity_tbl PO_TBL_VARCHAR2000,
547: wip_entity_id_tbl PO_TBL_NUMBER,
548: wip_line_code_tbl PO_TBL_VARCHAR30,
549: wip_line_id_tbl PO_TBL_NUMBER,
550: bom_resource_code_tbl PO_TBL_VARCHAR30,
551: bom_resource_id_tbl PO_TBL_NUMBER,
552: charge_account_tbl PO_TBL_VARCHAR2000,
546: wip_entity_tbl PO_TBL_VARCHAR2000,
547: wip_entity_id_tbl PO_TBL_NUMBER,
548: wip_line_code_tbl PO_TBL_VARCHAR30,
549: wip_line_id_tbl PO_TBL_NUMBER,
550: bom_resource_code_tbl PO_TBL_VARCHAR30,
551: bom_resource_id_tbl PO_TBL_NUMBER,
552: charge_account_tbl PO_TBL_VARCHAR2000,
553: charge_account_id_tbl PO_TBL_NUMBER,
554: dest_charge_account_id_tbl PO_TBL_NUMBER,
551: bom_resource_id_tbl PO_TBL_NUMBER,
552: charge_account_tbl PO_TBL_VARCHAR2000,
553: charge_account_id_tbl PO_TBL_NUMBER,
554: dest_charge_account_id_tbl PO_TBL_NUMBER,
555: project_accounting_context_tbl PO_TBL_VARCHAR30,
556: award_num_tbl PO_TBL_VARCHAR30,
557: award_id_tbl PO_TBL_NUMBER,
558: project_tbl PO_TBL_VARCHAR30,
559: project_id_tbl PO_TBL_NUMBER,
552: charge_account_tbl PO_TBL_VARCHAR2000,
553: charge_account_id_tbl PO_TBL_NUMBER,
554: dest_charge_account_id_tbl PO_TBL_NUMBER,
555: project_accounting_context_tbl PO_TBL_VARCHAR30,
556: award_num_tbl PO_TBL_VARCHAR30,
557: award_id_tbl PO_TBL_NUMBER,
558: project_tbl PO_TBL_VARCHAR30,
559: project_id_tbl PO_TBL_NUMBER,
560: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
554: dest_charge_account_id_tbl PO_TBL_NUMBER,
555: project_accounting_context_tbl PO_TBL_VARCHAR30,
556: award_num_tbl PO_TBL_VARCHAR30,
557: award_id_tbl PO_TBL_NUMBER,
558: project_tbl PO_TBL_VARCHAR30,
559: project_id_tbl PO_TBL_NUMBER,
560: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
561: task_id_tbl PO_TBL_NUMBER,
562: expenditure_tbl PO_TBL_VARCHAR100,
559: project_id_tbl PO_TBL_NUMBER,
560: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
561: task_id_tbl PO_TBL_NUMBER,
562: expenditure_tbl PO_TBL_VARCHAR100,
563: expenditure_type_tbl PO_TBL_VARCHAR30,
564: expenditure_org_tbl PO_TBL_VARCHAR100,
565: expenditure_org_id_tbl PO_TBL_NUMBER,
566: expenditure_item_date_tbl PO_TBL_DATE,
567: end_item_unit_number_tbl PO_TBL_VARCHAR30,
563: expenditure_type_tbl PO_TBL_VARCHAR30,
564: expenditure_org_tbl PO_TBL_VARCHAR100,
565: expenditure_org_id_tbl PO_TBL_NUMBER,
566: expenditure_item_date_tbl PO_TBL_DATE,
567: end_item_unit_number_tbl PO_TBL_VARCHAR30,
568: dest_context_tbl PO_TBL_VARCHAR30,
569: gl_encumbered_date_tbl PO_TBL_DATE,
570: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
571: variance_account_id_tbl PO_TBL_NUMBER,
564: expenditure_org_tbl PO_TBL_VARCHAR100,
565: expenditure_org_id_tbl PO_TBL_NUMBER,
566: expenditure_item_date_tbl PO_TBL_DATE,
567: end_item_unit_number_tbl PO_TBL_VARCHAR30,
568: dest_context_tbl PO_TBL_VARCHAR30,
569: gl_encumbered_date_tbl PO_TBL_DATE,
570: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
571: variance_account_id_tbl PO_TBL_NUMBER,
572: accrual_account_id_tbl PO_TBL_NUMBER,
566: expenditure_item_date_tbl PO_TBL_DATE,
567: end_item_unit_number_tbl PO_TBL_VARCHAR30,
568: dest_context_tbl PO_TBL_VARCHAR30,
569: gl_encumbered_date_tbl PO_TBL_DATE,
570: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
571: variance_account_id_tbl PO_TBL_NUMBER,
572: accrual_account_id_tbl PO_TBL_NUMBER,
573: budget_account_id_tbl PO_TBL_NUMBER,
574: dest_variance_account_id_tbl PO_TBL_NUMBER,
571: variance_account_id_tbl PO_TBL_NUMBER,
572: accrual_account_id_tbl PO_TBL_NUMBER,
573: budget_account_id_tbl PO_TBL_NUMBER,
574: dest_variance_account_id_tbl PO_TBL_NUMBER,
575: dest_subinventory_tbl PO_TBL_VARCHAR30,
576: amount_ordered_tbl PO_TBL_NUMBER,
577: quantity_ordered_tbl PO_TBL_NUMBER,
578: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
579: wip_operation_seq_num_tbl PO_TBL_NUMBER,
580: wip_resource_seq_num_tbl PO_TBL_NUMBER,
581: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
582: recovery_rate_tbl PO_TBL_NUMBER,
583: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
584: account_segment1_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
581: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
582: recovery_rate_tbl PO_TBL_NUMBER,
583: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
584: account_segment1_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
582: recovery_rate_tbl PO_TBL_NUMBER,
583: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
584: account_segment1_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
583: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
584: account_segment1_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
584: account_segment1_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
585: account_segment2_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
586: account_segment3_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
587: account_segment4_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
588: account_segment5_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
589: account_segment6_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
590: account_segment7_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
591: account_segment8_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
592: account_segment9_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
593: account_segment10_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
594: account_segment11_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
595: account_segment12_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
596: account_segment13_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
597: account_segment14_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
598: account_segment15_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
599: account_segment16_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
600: account_segment17_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
601: account_segment18_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
602: account_segment19_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
603: account_segment20_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
604: account_segment21_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
605: account_segment22_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
613: account_segment30_tbl PO_TBL_VARCHAR30,
606: account_segment23_tbl PO_TBL_VARCHAR30,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
613: account_segment30_tbl PO_TBL_VARCHAR30,
614: dist_attribute1_tbl PO_TBL_VARCHAR2000,
607: account_segment24_tbl PO_TBL_VARCHAR30,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
613: account_segment30_tbl PO_TBL_VARCHAR30,
614: dist_attribute1_tbl PO_TBL_VARCHAR2000,
615: dist_attribute2_tbl PO_TBL_VARCHAR2000,
608: account_segment25_tbl PO_TBL_VARCHAR30,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
613: account_segment30_tbl PO_TBL_VARCHAR30,
614: dist_attribute1_tbl PO_TBL_VARCHAR2000,
615: dist_attribute2_tbl PO_TBL_VARCHAR2000,
616: dist_attribute3_tbl PO_TBL_VARCHAR2000,
609: account_segment26_tbl PO_TBL_VARCHAR30,
610: account_segment27_tbl PO_TBL_VARCHAR30,
611: account_segment28_tbl PO_TBL_VARCHAR30,
612: account_segment29_tbl PO_TBL_VARCHAR30,
613: account_segment30_tbl PO_TBL_VARCHAR30,
614: dist_attribute1_tbl PO_TBL_VARCHAR2000,
615: dist_attribute2_tbl PO_TBL_VARCHAR2000,
616: dist_attribute3_tbl PO_TBL_VARCHAR2000,
617: dist_attribute4_tbl PO_TBL_VARCHAR2000,
631: partial_funded_flag_tbl PO_TBL_VARCHAR1,
632: funded_value_tbl PO_TBL_NUMBER,
633:
634: -- ACRN proj
635: ACRN_tbl PO_TBL_VARCHAR30,
636:
637: -- standard who columns
638: last_updated_by_tbl PO_TBL_NUMBER,
639: last_update_date_tbl PO_TBL_DATE,
645: program_id_tbl PO_TBL_NUMBER,
646: program_update_date_tbl PO_TBL_DATE,
647:
648: -- attributes exist in txn table but not in interface table
649: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
650: award_set_id_tbl PO_TBL_NUMBER, -- bug5201306
651:
652: -- attributes read from line location record
653: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
651:
652: -- attributes read from line location record
653: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
654: loc_line_loc_id_tbl PO_TBL_NUMBER,
655: loc_shipment_type_tbl PO_TBL_VARCHAR30,
656: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
657: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
658: loc_need_by_date_tbl PO_TBL_DATE,
659: loc_promised_date_tbl PO_TBL_DATE,
675: loc_attribute14_tbl PO_TBL_VARCHAR2000,
676: loc_attribute15_tbl PO_TBL_VARCHAR2000,
677:
678: -- attributes read from line record
679: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
680: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
681: ln_item_id_tbl PO_TBL_NUMBER,
682: ln_category_id_tbl PO_TBL_NUMBER,
683: ln_line_type_id_tbl PO_TBL_NUMBER,
676: loc_attribute15_tbl PO_TBL_VARCHAR2000,
677:
678: -- attributes read from line record
679: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
680: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
681: ln_item_id_tbl PO_TBL_NUMBER,
682: ln_category_id_tbl PO_TBL_NUMBER,
683: ln_line_type_id_tbl PO_TBL_NUMBER,
684: ln_po_line_id_tbl PO_TBL_NUMBER,
703: hd_agent_id_tbl PO_TBL_NUMBER,
704: hd_po_header_id_tbl PO_TBL_NUMBER,
705: hd_rate_date_tbl PO_TBL_DATE,
706: hd_rate_tbl PO_TBL_NUMBER,
707: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
708: hd_vendor_id_tbl PO_TBL_NUMBER,
709: hd_attribute1_tbl PO_TBL_VARCHAR2000,
710: hd_attribute2_tbl PO_TBL_VARCHAR2000,
711: hd_attribute3_tbl PO_TBL_VARCHAR2000,
734: error_flag_tbl PO_TBL_VARCHAR1,
735: rec_count NUMBER,
736:
737: --attributes added for pdoi clm integration
738: clm_defence_funding_tbl PO_TBL_VARCHAR30,
739: clm_fms_case_number_tbl PO_TBL_VARCHAR240,
740: clm_agency_acct_identifier_tbl PO_TBL_VARCHAR100,
741: clm_misc_loa_tbl PO_TBL_VARCHAR240,
742: group_line_id_tbl PO_TBL_NUMBER,
755: intf_price_diff_id_tbl PO_TBL_NUMBER,
756: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
757: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
758: price_diff_num_tbl PO_TBL_NUMBER,
759: price_type_tbl PO_TBL_VARCHAR30,
760: entity_type_tbl PO_TBL_VARCHAR30,
761: entity_id_tbl PO_TBL_NUMBER,
762: multiplier_tbl PO_TBL_NUMBER,
763: min_multiplier_tbl PO_TBL_NUMBER,
756: intf_line_id_tbl PO_TBL_NUMBER, -- bug 5215781
757: intf_header_id_tbl PO_TBL_NUMBER, -- bug 5215781
758: price_diff_num_tbl PO_TBL_NUMBER,
759: price_type_tbl PO_TBL_VARCHAR30,
760: entity_type_tbl PO_TBL_VARCHAR30,
761: entity_id_tbl PO_TBL_NUMBER,
762: multiplier_tbl PO_TBL_NUMBER,
763: min_multiplier_tbl PO_TBL_NUMBER,
764: max_multiplier_tbl PO_TBL_NUMBER,