[Home] [Help]
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,
30: terms_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,
32: vendor_num_tbl PO_TBL_VARCHAR30,
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,
32: vendor_num_tbl PO_TBL_VARCHAR30,
33: vendor_id_tbl PO_TBL_NUMBER,
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,
51: from_type_lookup_code_tbl PO_TBL_VARCHAR30,
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,
57: print_count_tbl PO_TBL_NUMBER,
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,
57: print_count_tbl PO_TBL_NUMBER,
58: frozen_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,
62: acceptance_due_date_tbl PO_TBL_DATE,
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,
62: acceptance_due_date_tbl PO_TBL_DATE,
63: amount_to_encumber_tbl PO_TBL_NUMBER,
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
115: last_update_date_tbl PO_TBL_DATE,
116: last_updated_by_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,
131: quotation_class_code_tbl PO_TBL_VARCHAR30,
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:
136: -- attributes added for processing purpose
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,
139: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
140:
141: --attributes added for CLM PDOI Integration
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,
210: template_id_tbl PO_TBL_NUMBER,
211: item_desc_tbl PO_TBL_VARCHAR2000,
214: from_header_id_tbl PO_TBL_NUMBER,
215: from_line_id_tbl PO_TBL_NUMBER,
216: list_price_per_unit_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,
216: list_price_per_unit_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,
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,
228: effective_date_tbl PO_TBL_DATE,
229: expiration_date_tbl PO_TBL_DATE,
230: attribute14_tbl PO_TBL_VARCHAR2000,
231: price_update_tolerance_tbl PO_TBL_NUMBER,
228: effective_date_tbl PO_TBL_DATE,
229: expiration_date_tbl PO_TBL_DATE,
230: attribute14_tbl PO_TBL_VARCHAR2000,
231: price_update_tolerance_tbl PO_TBL_NUMBER,
232: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
233: -- PDOI for Complex PO Project
234: retainage_rate_tbl PO_TBL_NUMBER,
235: max_retainage_amount_tbl PO_TBL_NUMBER,
236: progress_payment_rate_tbl PO_TBL_NUMBER,
236: progress_payment_rate_tbl PO_TBL_NUMBER,
237: recoupment_rate_tbl PO_TBL_NUMBER,
238: advance_amount_tbl PO_TBL_NUMBER,
239:
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,
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,
284:
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,
284:
285: -- attributes read from the header interface record
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,
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,
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,
302:
303: -- attributes added for uniqueness checking
304: origin_line_num_tbl PO_TBL_NUMBER,
305: group_num_tbl PO_TBL_NUMBER,
302:
303: -- attributes added for uniqueness checking
304: origin_line_num_tbl PO_TBL_NUMBER,
305: group_num_tbl PO_TBL_NUMBER,
306: match_line_found_tbl PO_TBL_VARCHAR1,
307: line_num_unique_tbl PO_TBL_VARCHAR1,
308: clm_info_flag_tbl PO_TBL_VARCHAR1, /* 10354034 */
309:
310:
303: -- attributes added for uniqueness checking
304: origin_line_num_tbl PO_TBL_NUMBER,
305: group_num_tbl PO_TBL_NUMBER,
306: match_line_found_tbl PO_TBL_VARCHAR1,
307: line_num_unique_tbl PO_TBL_VARCHAR1,
308: clm_info_flag_tbl PO_TBL_VARCHAR1, /* 10354034 */
309:
310:
311: -- attributes added for processing purpose
304: origin_line_num_tbl PO_TBL_NUMBER,
305: group_num_tbl PO_TBL_NUMBER,
306: match_line_found_tbl PO_TBL_VARCHAR1,
307: line_num_unique_tbl PO_TBL_VARCHAR1,
308: clm_info_flag_tbl PO_TBL_VARCHAR1, /* 10354034 */
309:
310:
311: -- attributes added for processing purpose
312: error_flag_tbl PO_TBL_VARCHAR1,
308: clm_info_flag_tbl PO_TBL_VARCHAR1, /* 10354034 */
309:
310:
311: -- attributes added for processing purpose
312: error_flag_tbl PO_TBL_VARCHAR1,
313: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
314: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
315: rec_count NUMBER,
316: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
309:
310:
311: -- attributes added for processing purpose
312: error_flag_tbl PO_TBL_VARCHAR1,
313: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
314: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
315: rec_count NUMBER,
316: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
317:
310:
311: -- attributes added for processing purpose
312: error_flag_tbl PO_TBL_VARCHAR1,
313: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
314: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
315: rec_count NUMBER,
316: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
317:
318: --attributes added for pdoi clm integration project
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,
325: clm_base_line_num_tbl PO_TBL_NUMBER,
326: clm_option_num_tbl PO_TBL_NUMBER,
327: clm_option_from_date_tbl PO_TBL_DATE,
328: clm_option_to_date_tbl PO_TBL_DATE,
326: clm_option_num_tbl PO_TBL_NUMBER,
327: clm_option_from_date_tbl PO_TBL_DATE,
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,
327: clm_option_from_date_tbl PO_TBL_DATE,
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,
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,
337: clm_min_total_quantity_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,
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,
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,
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,
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,
384: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
385: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
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,
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,
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,
391: invoice_close_tolerance_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,
395: fob_tbl PO_TBL_VARCHAR30,
396: freight_carrier_tbl PO_TBL_VARCHAR30,
397: freight_term_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,
415: payment_type_tbl PO_TBL_VARCHAR30, -- PDOI for Complex PO Project
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,
479: hd_currency_code_tbl PO_TBL_VARCHAR30, -- 9294987 bug
511: ln_category_id_tbl PO_TBL_NUMBER,
512: line_ref_index_tbl PO_TBL_NUMBER,
513:
514: -- attributes added for processing purpose
515: shipment_num_unique_tbl PO_TBL_VARCHAR1,
516: error_flag_tbl PO_TBL_VARCHAR1,
517: rec_count NUMBER,
518: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
519:
512: line_ref_index_tbl PO_TBL_NUMBER,
513:
514: -- attributes added for processing purpose
515: shipment_num_unique_tbl PO_TBL_VARCHAR1,
516: error_flag_tbl PO_TBL_VARCHAR1,
517: rec_count NUMBER,
518: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
519:
520:
534: intf_line_id_tbl PO_TBL_NUMBER,
535: intf_line_loc_id_tbl PO_TBL_NUMBER,
536: po_dist_id_tbl PO_TBL_NUMBER,
537: dist_num_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,
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,
548: wip_line_code_tbl PO_TBL_VARCHAR30,
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,
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,
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,
568: dest_context_tbl PO_TBL_VARCHAR30,
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,
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,
627: dist_attribute14_tbl PO_TBL_VARCHAR2000,
628: dist_attribute15_tbl PO_TBL_VARCHAR2000,
629:
630: -- CLM Partial Funding Changes
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,
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,
660: loc_price_override_tbl PO_TBL_NUMBER,
661: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
727:
728: -- attributes added for processing
729: ship_to_ou_id_tbl PO_TBL_NUMBER,
730: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
731: item_status_tbl PO_TBL_VARCHAR1,
732: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
733: dist_num_unique_tbl PO_TBL_VARCHAR1,
734: error_flag_tbl PO_TBL_VARCHAR1,
735: rec_count NUMBER,
728: -- attributes added for processing
729: ship_to_ou_id_tbl PO_TBL_NUMBER,
730: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
731: item_status_tbl PO_TBL_VARCHAR1,
732: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
733: dist_num_unique_tbl PO_TBL_VARCHAR1,
734: error_flag_tbl PO_TBL_VARCHAR1,
735: rec_count NUMBER,
736:
729: ship_to_ou_id_tbl PO_TBL_NUMBER,
730: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
731: item_status_tbl PO_TBL_VARCHAR1,
732: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
733: dist_num_unique_tbl PO_TBL_VARCHAR1,
734: error_flag_tbl PO_TBL_VARCHAR1,
735: rec_count NUMBER,
736:
737: --attributes added for pdoi clm integration
730: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
731: item_status_tbl PO_TBL_VARCHAR1,
732: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
733: dist_num_unique_tbl PO_TBL_VARCHAR1,
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,
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,
743: quantity_funded_tbl PO_TBL_NUMBER,
744: amount_funded_tbl PO_TBL_NUMBER
773: draft_id_tbl PO_TBL_NUMBER,
774: hd_style_id_tbl PO_TBL_NUMBER,
775:
776: -- attributes added for processing
777: error_flag_tbl PO_TBL_VARCHAR1,
778: price_diff_num_unique_tbl PO_TBL_VARCHAR1,
779: rec_count NUMBER
780:
781: -- ATTENTION: If you are adding new attributes to this record type, see
774: hd_style_id_tbl PO_TBL_NUMBER,
775:
776: -- attributes added for processing
777: error_flag_tbl PO_TBL_VARCHAR1,
778: price_diff_num_unique_tbl PO_TBL_VARCHAR1,
779: rec_count NUMBER
780:
781: -- ATTENTION: If you are adding new attributes to this record type, see
782: -- the message above first.
801:
802: -- attributes added for processing purpose
803: attribute_values_id_tbl PO_TBL_NUMBER,
804: source_tbl DBMS_SQL.VARCHAR2_TABLE,
805: error_flag_tbl PO_TBL_VARCHAR1,
806:
807: rec_count NUMBER
808:
809: -- ATTENTION: If you are adding new attributes to this record type, see
830: -- attribute from headers
831: draft_id_tbl PO_TBL_NUMBER,
832:
833: -- attributes added for processing purpose
834: error_flag_tbl PO_TBL_VARCHAR1,
835: attribute_values_tlp_id_tbl PO_TBL_NUMBER,
836: source_tbl DBMS_SQL.VARCHAR2_TABLE,
837:
838: rec_count NUMBER