[Home] [Help]
184: intf_line_id_tbl PO_TBL_NUMBER,
185: intf_header_id_tbl PO_TBL_NUMBER,
186: po_header_id_tbl PO_TBL_NUMBER,
187: po_line_id_tbl PO_TBL_NUMBER,
188: action_tbl PO_TBL_VARCHAR30,
189: document_num_tbl PO_TBL_VARCHAR30,
190: item_tbl PO_TBL_VARCHAR2000,
191: vendor_product_num_tbl PO_TBL_VARCHAR30,
192: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
185: intf_header_id_tbl PO_TBL_NUMBER,
186: po_header_id_tbl PO_TBL_NUMBER,
187: po_line_id_tbl PO_TBL_NUMBER,
188: action_tbl PO_TBL_VARCHAR30,
189: document_num_tbl PO_TBL_VARCHAR30,
190: item_tbl PO_TBL_VARCHAR2000,
191: vendor_product_num_tbl PO_TBL_VARCHAR30,
192: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
193: item_id_tbl PO_TBL_NUMBER,
187: po_line_id_tbl PO_TBL_NUMBER,
188: action_tbl PO_TBL_VARCHAR30,
189: document_num_tbl PO_TBL_VARCHAR30,
190: item_tbl PO_TBL_VARCHAR2000,
191: vendor_product_num_tbl PO_TBL_VARCHAR30,
192: supplier_part_auxid_tbl PO_TBL_VARCHAR2000,
193: item_id_tbl PO_TBL_NUMBER,
194: item_revision_tbl PO_TBL_VARCHAR5,
195: job_business_group_name_tbl PO_TBL_VARCHAR2000,
200: category_id_tbl PO_TBL_NUMBER,
201: ip_category_tbl PO_TBL_VARCHAR2000,
202: ip_category_id_tbl PO_TBL_NUMBER,
203: uom_code_tbl PO_TBL_VARCHAR5,
204: unit_of_measure_tbl PO_TBL_VARCHAR30,
205: line_type_tbl PO_TBL_VARCHAR30,
206: line_type_id_tbl PO_TBL_NUMBER,
207: un_number_tbl PO_TBL_VARCHAR30,
208: un_number_id_tbl PO_TBL_NUMBER,
201: ip_category_tbl PO_TBL_VARCHAR2000,
202: ip_category_id_tbl PO_TBL_NUMBER,
203: uom_code_tbl PO_TBL_VARCHAR5,
204: unit_of_measure_tbl PO_TBL_VARCHAR30,
205: line_type_tbl PO_TBL_VARCHAR30,
206: line_type_id_tbl PO_TBL_NUMBER,
207: un_number_tbl PO_TBL_VARCHAR30,
208: un_number_id_tbl PO_TBL_NUMBER,
209: hazard_class_tbl PO_TBL_VARCHAR100,
203: uom_code_tbl PO_TBL_VARCHAR5,
204: unit_of_measure_tbl PO_TBL_VARCHAR30,
205: line_type_tbl PO_TBL_VARCHAR30,
206: line_type_id_tbl PO_TBL_NUMBER,
207: un_number_tbl PO_TBL_VARCHAR30,
208: un_number_id_tbl PO_TBL_NUMBER,
209: hazard_class_tbl PO_TBL_VARCHAR100,
210: hazard_class_id_tbl PO_TBL_NUMBER,
211: template_name_tbl PO_TBL_VARCHAR30,
207: un_number_tbl PO_TBL_VARCHAR30,
208: un_number_id_tbl PO_TBL_NUMBER,
209: hazard_class_tbl PO_TBL_VARCHAR100,
210: hazard_class_id_tbl PO_TBL_NUMBER,
211: template_name_tbl PO_TBL_VARCHAR30,
212: template_id_tbl PO_TBL_NUMBER,
213: item_desc_tbl PO_TBL_VARCHAR2000,
214: unit_price_tbl PO_TBL_NUMBER,
215: base_unit_price_tbl PO_TBL_NUMBER,
219: market_price_tbl PO_TBL_NUMBER,
220: capital_expense_flag_tbl PO_TBL_VARCHAR1,
221: min_release_amount_tbl PO_TBL_NUMBER,
222: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
223: price_type_tbl PO_TBL_VARCHAR30,
224: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
225: closed_code_tbl PO_TBL_VARCHAR30,
226: quantity_tbl PO_TBL_NUMBER,
227: line_num_tbl PO_TBL_NUMBER,
220: capital_expense_flag_tbl PO_TBL_VARCHAR1,
221: min_release_amount_tbl PO_TBL_NUMBER,
222: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
223: price_type_tbl PO_TBL_VARCHAR30,
224: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
225: closed_code_tbl PO_TBL_VARCHAR30,
226: quantity_tbl PO_TBL_NUMBER,
227: line_num_tbl PO_TBL_NUMBER,
228: shipment_num_tbl PO_TBL_NUMBER,
221: min_release_amount_tbl PO_TBL_NUMBER,
222: allow_price_override_flag_tbl PO_TBL_VARCHAR1,
223: price_type_tbl PO_TBL_VARCHAR30,
224: price_break_lookup_code_tbl PO_TBL_VARCHAR30,
225: closed_code_tbl PO_TBL_VARCHAR30,
226: quantity_tbl PO_TBL_NUMBER,
227: line_num_tbl PO_TBL_NUMBER,
228: shipment_num_tbl PO_TBL_NUMBER,
229: price_chg_accept_flag_tbl PO_TBL_VARCHAR1,
235: negotiated_flag_tbl PO_TBL_VARCHAR1,
236: amount_tbl PO_TBL_NUMBER,
237: contractor_last_name_tbl PO_TBL_VARCHAR2000,
238: contractor_first_name_tbl PO_TBL_VARCHAR2000,
239: over_tolerance_err_flag_tbl PO_TBL_VARCHAR30,
240: not_to_exceed_price_tbl PO_TBL_NUMBER,
241: po_release_id_tbl PO_TBL_NUMBER,
242: release_num_tbl PO_TBL_NUMBER,
243: source_shipment_id_tbl PO_TBL_NUMBER,
240: not_to_exceed_price_tbl PO_TBL_NUMBER,
241: po_release_id_tbl PO_TBL_NUMBER,
242: release_num_tbl PO_TBL_NUMBER,
243: source_shipment_id_tbl PO_TBL_NUMBER,
244: contract_num_tbl PO_TBL_VARCHAR30,
245: contract_id_tbl PO_TBL_NUMBER,
246: type_1099_tbl PO_TBL_VARCHAR30,
247: closed_by_tbl PO_TBL_NUMBER,
248: closed_date_tbl PO_TBL_DATE,
242: release_num_tbl PO_TBL_NUMBER,
243: source_shipment_id_tbl PO_TBL_NUMBER,
244: contract_num_tbl PO_TBL_VARCHAR30,
245: contract_id_tbl PO_TBL_NUMBER,
246: type_1099_tbl PO_TBL_VARCHAR30,
247: closed_by_tbl PO_TBL_NUMBER,
248: closed_date_tbl PO_TBL_DATE,
249: committed_amount_tbl PO_TBL_NUMBER,
250: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
246: type_1099_tbl PO_TBL_VARCHAR30,
247: closed_by_tbl PO_TBL_NUMBER,
248: closed_date_tbl PO_TBL_DATE,
249: committed_amount_tbl PO_TBL_NUMBER,
250: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
251: weight_uom_code_tbl PO_TBL_VARCHAR5,
252: volume_uom_code_tbl PO_TBL_VARCHAR5,
253: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
254: secondary_quantity_tbl PO_TBL_NUMBER,
249: committed_amount_tbl PO_TBL_NUMBER,
250: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
251: weight_uom_code_tbl PO_TBL_VARCHAR5,
252: volume_uom_code_tbl PO_TBL_VARCHAR5,
253: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
254: secondary_quantity_tbl PO_TBL_NUMBER,
255: preferred_grade_tbl PO_TBL_VARCHAR2000,
256: process_code_tbl PO_TBL_VARCHAR30,
257: parent_interface_line_id_tbl PO_TBL_NUMBER,
252: volume_uom_code_tbl PO_TBL_VARCHAR5,
253: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
254: secondary_quantity_tbl PO_TBL_NUMBER,
255: preferred_grade_tbl PO_TBL_VARCHAR2000,
256: process_code_tbl PO_TBL_VARCHAR30,
257: parent_interface_line_id_tbl PO_TBL_NUMBER,
258: file_line_language_tbl PO_TBL_VARCHAR5,
259: requisition_line_id_tbl PO_TBL_NUMBER,
260: group_line_id_tbl PO_TBL_NUMBER,
305: program_id_tbl PO_TBL_NUMBER,
306: program_update_date_tbl PO_TBL_DATE,
307:
308: -- attributes that are in line txn table but not in interface table
309: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
310: purchase_basis_tbl PO_TBL_VARCHAR30,
311: matching_basis_tbl PO_TBL_VARCHAR30,
312: unordered_flag_tbl PO_TBL_VARCHAR1,
313: cancel_flag_tbl PO_TBL_VARCHAR1,
306: program_update_date_tbl PO_TBL_DATE,
307:
308: -- attributes that are in line txn table but not in interface table
309: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
310: purchase_basis_tbl PO_TBL_VARCHAR30,
311: matching_basis_tbl PO_TBL_VARCHAR30,
312: unordered_flag_tbl PO_TBL_VARCHAR1,
313: cancel_flag_tbl PO_TBL_VARCHAR1,
314: quantity_committed_tbl PO_TBL_NUMBER,
307:
308: -- attributes that are in line txn table but not in interface table
309: order_type_lookup_code_tbl PO_TBL_VARCHAR30,
310: purchase_basis_tbl PO_TBL_VARCHAR30,
311: matching_basis_tbl PO_TBL_VARCHAR30,
312: unordered_flag_tbl PO_TBL_VARCHAR1,
313: cancel_flag_tbl PO_TBL_VARCHAR1,
314: quantity_committed_tbl PO_TBL_NUMBER,
315: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
311: matching_basis_tbl PO_TBL_VARCHAR30,
312: unordered_flag_tbl PO_TBL_VARCHAR1,
313: cancel_flag_tbl PO_TBL_VARCHAR1,
314: quantity_committed_tbl PO_TBL_NUMBER,
315: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
316: taxable_flag_tbl po_tbl_varchar1,
317: tax_name_tbl PO_TBL_VARCHAR30,
318: org_id_tbl po_tbl_number,
319:
313: cancel_flag_tbl PO_TBL_VARCHAR1,
314: quantity_committed_tbl PO_TBL_NUMBER,
315: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
316: taxable_flag_tbl po_tbl_varchar1,
317: tax_name_tbl PO_TBL_VARCHAR30,
318: org_id_tbl po_tbl_number,
319:
320: -- attributes read from the header interface record
321: draft_id_tbl PO_TBL_NUMBER,
318: org_id_tbl po_tbl_number,
319:
320: -- attributes read from the header interface record
321: draft_id_tbl PO_TBL_NUMBER,
322: hd_action_tbl PO_TBL_VARCHAR30,
323: hd_po_header_id_tbl PO_TBL_NUMBER,
324: hd_vendor_id_tbl PO_TBL_NUMBER,
325: hd_vendor_site_id_tbl PO_TBL_NUMBER,
326: hd_min_release_amount_tbl PO_TBL_NUMBER,
326: hd_min_release_amount_tbl PO_TBL_NUMBER,
327: hd_start_date_tbl PO_TBL_DATE,
328: hd_end_date_tbl PO_TBL_DATE,
329: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
330: hd_currency_code_tbl PO_TBL_VARCHAR30,
331: hd_created_language_tbl PO_TBL_VARCHAR5,
332: hd_style_id_tbl PO_TBL_NUMBER,
333: hd_rate_type_tbl PO_TBL_VARCHAR30,
334: hd_rate_date_tbl PO_TBL_DATE,
329: hd_global_agreement_flag_tbl PO_TBL_VARCHAR1,
330: hd_currency_code_tbl PO_TBL_VARCHAR30,
331: hd_created_language_tbl PO_TBL_VARCHAR5,
332: hd_style_id_tbl PO_TBL_NUMBER,
333: hd_rate_type_tbl PO_TBL_VARCHAR30,
334: hd_rate_date_tbl PO_TBL_DATE,
335: hd_rate_tbl PO_TBL_NUMBER,
336: hd_pcard_id_tbl po_tbl_number,
337:
338: -- attributes added for item defaults type processing
339: it_list_price_per_unit_tbl po_tbl_number,
340: it_market_price_tbl po_tbl_number,
341: it_taxable_flag_tbl po_tbl_varchar1,
342: it_unit_meas_lookup_code_tbl po_tbl_varchar30,
343: it_inspect_req_flag_tbl po_tbl_varchar1,
344: it_receipt_req_flag_tbl po_tbl_varchar1,
345: it_invoice_tolerance_tbl po_tbl_number,
346: it_rcv_tolerance_tbl po_tbl_number,
343: it_inspect_req_flag_tbl po_tbl_varchar1,
344: it_receipt_req_flag_tbl po_tbl_varchar1,
345: it_invoice_tolerance_tbl po_tbl_number,
346: it_rcv_tolerance_tbl po_tbl_number,
347: it_secondary_uom_code_tbl po_tbl_varchar30,
348: it_grade_control_flag_tbl po_tbl_varchar1,
349:
350: -- attributes for receiving controls.
351: -- The following attributes are equivalent to PO_INTERFACE_S.rcv_controls_type
348: it_grade_control_flag_tbl po_tbl_varchar1,
349:
350: -- attributes for receiving controls.
351: -- The following attributes are equivalent to PO_INTERFACE_S.rcv_controls_type
352: rc_enforce_shipto_loc_code_tbl po_tbl_varchar30,
353: rc_subst_receipt_flag_tbl po_tbl_varchar1,
354: rc_receiving_routing_id_tbl po_tbl_number,
355: rc_qty_rcv_tolerance_tbl po_tbl_number,
356: rc_qty_rcv_exception_code_tbl po_tbl_varchar30,
352: rc_enforce_shipto_loc_code_tbl po_tbl_varchar30,
353: rc_subst_receipt_flag_tbl po_tbl_varchar1,
354: rc_receiving_routing_id_tbl po_tbl_number,
355: rc_qty_rcv_tolerance_tbl po_tbl_number,
356: rc_qty_rcv_exception_code_tbl po_tbl_varchar30,
357: rc_days_early_recpt_tbl po_tbl_number,
358: rc_days_late_recpt_tbl po_tbl_number,
359: rc_receipt_days_excep_code_tbl po_tbl_varchar30,
360:
355: rc_qty_rcv_tolerance_tbl po_tbl_number,
356: rc_qty_rcv_exception_code_tbl po_tbl_varchar30,
357: rc_days_early_recpt_tbl po_tbl_number,
358: rc_days_late_recpt_tbl po_tbl_number,
359: rc_receipt_days_excep_code_tbl po_tbl_varchar30,
360:
361:
362:
363:
363:
364:
365: -- attributes added for location processing
366: create_line_loc_tbl PO_TBL_VARCHAR1,
367: destination_type_code_tbl po_tbl_varchar30,
368: dest_organization_id_tbl po_tbl_number,
369: deliver_to_loc_id_tbl po_tbl_number,
370: tax_code_id_tbl po_tbl_number,
371: txn_flow_header_id_tbl PO_TBL_NUMBER,
411: clm_exercised_flag_tbl PO_TBL_VARCHAR1, -- Bug 9960752
412: clm_exercised_date_tbl PO_TBL_DATE, -- Bug 9960752
413: --CLM Phase4 Changes
414: clm_exhibit_name_tbl PO_TBL_VARCHAR20,
415: clm_delivery_event_code_tbl PO_TBL_VARCHAR30,
416: clm_delivery_period_tbl PO_TBL_NUMBER,
417: clm_promise_period_tbl PO_TBL_NUMBER,
418: clm_pop_duration_tbl PO_TBL_NUMBER,
419: clm_delivery_period_uom_tbl PO_TBL_VARCHAR25,
432: intf_line_loc_id_tbl PO_TBL_NUMBER,
433: intf_line_id_tbl PO_TBL_NUMBER,
434: intf_header_id_tbl PO_TBL_NUMBER,
435: shipment_num_tbl PO_TBL_NUMBER,
436: shipment_type_tbl PO_TBL_VARCHAR30,
437: line_loc_id_tbl PO_TBL_NUMBER,
438: ship_to_org_code_tbl PO_TBL_VARCHAR5,
439: ship_to_org_id_tbl PO_TBL_NUMBER,
440: ship_to_loc_tbl PO_TBL_VARCHAR100,
440: ship_to_loc_tbl PO_TBL_VARCHAR100,
441: ship_to_loc_id_tbl PO_TBL_NUMBER,
442: payment_terms_tbl PO_TBL_VARCHAR100,
443: terms_id_tbl PO_TBL_NUMBER,
444: receiving_routing_tbl PO_TBL_VARCHAR30,
445: receiving_routing_id_tbl PO_TBL_NUMBER,
446: inspection_required_flag_tbl PO_TBL_VARCHAR1,
447: receipt_required_flag_tbl PO_TBL_VARCHAR1,
448: price_override_tbl PO_TBL_NUMBER,
446: inspection_required_flag_tbl PO_TBL_VARCHAR1,
447: receipt_required_flag_tbl PO_TBL_VARCHAR1,
448: price_override_tbl PO_TBL_NUMBER,
449: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
450: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
451: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
452: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
453: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
454: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
447: receipt_required_flag_tbl PO_TBL_VARCHAR1,
448: price_override_tbl PO_TBL_NUMBER,
449: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
450: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
451: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
452: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
453: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
454: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
455: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
451: enforce_ship_to_loc_code_tbl PO_TBL_VARCHAR30,
452: allow_sub_receipts_flag_tbl PO_TBL_VARCHAR1,
453: days_early_receipt_allowed_tbl PO_TBL_NUMBER,
454: days_late_receipt_allowed_tbl PO_TBL_NUMBER,
455: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
456: invoice_close_tolerance_tbl PO_TBL_NUMBER,
457: receive_close_tolerance_tbl PO_TBL_NUMBER,
458: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459: firm_flag_tbl PO_TBL_VARCHAR30,
455: receipt_days_except_code_tbl PO_TBL_VARCHAR30,
456: invoice_close_tolerance_tbl PO_TBL_NUMBER,
457: receive_close_tolerance_tbl PO_TBL_NUMBER,
458: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459: firm_flag_tbl PO_TBL_VARCHAR30,
460: fob_tbl PO_TBL_VARCHAR30,
461: freight_carrier_tbl PO_TBL_VARCHAR30,
462: freight_term_tbl PO_TBL_VARCHAR30,
463: need_by_date_tbl PO_TBL_DATE,
456: invoice_close_tolerance_tbl PO_TBL_NUMBER,
457: receive_close_tolerance_tbl PO_TBL_NUMBER,
458: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459: firm_flag_tbl PO_TBL_VARCHAR30,
460: fob_tbl PO_TBL_VARCHAR30,
461: freight_carrier_tbl PO_TBL_VARCHAR30,
462: freight_term_tbl PO_TBL_VARCHAR30,
463: need_by_date_tbl PO_TBL_DATE,
464: promised_date_tbl PO_TBL_DATE,
457: receive_close_tolerance_tbl PO_TBL_NUMBER,
458: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459: firm_flag_tbl PO_TBL_VARCHAR30,
460: fob_tbl PO_TBL_VARCHAR30,
461: freight_carrier_tbl PO_TBL_VARCHAR30,
462: freight_term_tbl PO_TBL_VARCHAR30,
463: need_by_date_tbl PO_TBL_DATE,
464: promised_date_tbl PO_TBL_DATE,
465: quantity_tbl PO_TBL_NUMBER,
458: accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
459: firm_flag_tbl PO_TBL_VARCHAR30,
460: fob_tbl PO_TBL_VARCHAR30,
461: freight_carrier_tbl PO_TBL_VARCHAR30,
462: freight_term_tbl PO_TBL_VARCHAR30,
463: need_by_date_tbl PO_TBL_DATE,
464: promised_date_tbl PO_TBL_DATE,
465: quantity_tbl PO_TBL_NUMBER,
466: start_date_tbl PO_TBL_DATE,
466: start_date_tbl PO_TBL_DATE,
467: end_date_tbl PO_TBL_DATE,
468: note_to_receiver_tbl PO_TBL_VARCHAR2000,
469: price_discount_tbl PO_TBL_NUMBER,
470: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
471: secondary_quantity_tbl PO_TBL_NUMBER,
472: preferred_grade_tbl PO_TBL_VARCHAR2000,
473: tax_code_id_tbl PO_TBL_NUMBER,
474: tax_name_tbl PO_TBL_VARCHAR30,
470: secondary_unit_of_meas_tbl PO_TBL_VARCHAR30,
471: secondary_quantity_tbl PO_TBL_NUMBER,
472: preferred_grade_tbl PO_TBL_VARCHAR2000,
473: tax_code_id_tbl PO_TBL_NUMBER,
474: tax_name_tbl PO_TBL_VARCHAR30,
475: taxable_flag_tbl PO_TBL_VARCHAR1,
476: unit_of_measure_tbl PO_TBL_VARCHAR30,
477: value_basis_tbl PO_TBL_VARCHAR30,
478: matching_basis_tbl PO_TBL_VARCHAR30,
472: preferred_grade_tbl PO_TBL_VARCHAR2000,
473: tax_code_id_tbl PO_TBL_NUMBER,
474: tax_name_tbl PO_TBL_VARCHAR30,
475: taxable_flag_tbl PO_TBL_VARCHAR1,
476: unit_of_measure_tbl PO_TBL_VARCHAR30,
477: value_basis_tbl PO_TBL_VARCHAR30,
478: matching_basis_tbl PO_TBL_VARCHAR30,
479:
480: -- attributes in txn table but not in interface table
473: tax_code_id_tbl PO_TBL_NUMBER,
474: tax_name_tbl PO_TBL_VARCHAR30,
475: taxable_flag_tbl PO_TBL_VARCHAR1,
476: unit_of_measure_tbl PO_TBL_VARCHAR30,
477: value_basis_tbl PO_TBL_VARCHAR30,
478: matching_basis_tbl PO_TBL_VARCHAR30,
479:
480: -- attributes in txn table but not in interface table
481: match_option_tbl PO_TBL_VARCHAR30,
474: tax_name_tbl PO_TBL_VARCHAR30,
475: taxable_flag_tbl PO_TBL_VARCHAR1,
476: unit_of_measure_tbl PO_TBL_VARCHAR30,
477: value_basis_tbl PO_TBL_VARCHAR30,
478: matching_basis_tbl PO_TBL_VARCHAR30,
479:
480: -- attributes in txn table but not in interface table
481: match_option_tbl PO_TBL_VARCHAR30,
482: txn_flow_header_id_tbl PO_TBL_NUMBER,
477: value_basis_tbl PO_TBL_VARCHAR30,
478: matching_basis_tbl PO_TBL_VARCHAR30,
479:
480: -- attributes in txn table but not in interface table
481: match_option_tbl PO_TBL_VARCHAR30,
482: txn_flow_header_id_tbl PO_TBL_NUMBER,
483: outsourced_assembly_tbl PO_TBL_NUMBER,
484: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
485:
480: -- attributes in txn table but not in interface table
481: match_option_tbl PO_TBL_VARCHAR30,
482: txn_flow_header_id_tbl PO_TBL_NUMBER,
483: outsourced_assembly_tbl PO_TBL_NUMBER,
484: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
485:
486: -- standard who columns
487: last_updated_by_tbl PO_TBL_NUMBER,
488: last_update_date_tbl PO_TBL_DATE,
496:
497: -- attributes read from the line interface record
498: ln_po_line_id_tbl PO_TBL_NUMBER,
499: ln_item_id_tbl PO_TBL_NUMBER,
500: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
501: ln_action_tbl PO_TBL_VARCHAR30,
502: ln_unit_price_tbl PO_TBL_NUMBER,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
497: -- attributes read from the line interface record
498: ln_po_line_id_tbl PO_TBL_NUMBER,
499: ln_item_id_tbl PO_TBL_NUMBER,
500: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
501: ln_action_tbl PO_TBL_VARCHAR30,
502: ln_unit_price_tbl PO_TBL_NUMBER,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505: ln_closed_code_tbl PO_TBL_VARCHAR30,
500: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
501: ln_action_tbl PO_TBL_VARCHAR30,
502: ln_unit_price_tbl PO_TBL_NUMBER,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505: ln_closed_code_tbl PO_TBL_VARCHAR30,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
508: ln_item_revision_tbl PO_TBL_VARCHAR5,
501: ln_action_tbl PO_TBL_VARCHAR30,
502: ln_unit_price_tbl PO_TBL_NUMBER,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505: ln_closed_code_tbl PO_TBL_VARCHAR30,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
508: ln_item_revision_tbl PO_TBL_VARCHAR5,
509: ln_expiration_date_tbl PO_TBL_DATE,
502: ln_unit_price_tbl PO_TBL_NUMBER,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505: ln_closed_code_tbl PO_TBL_VARCHAR30,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
508: ln_item_revision_tbl PO_TBL_VARCHAR5,
509: ln_expiration_date_tbl PO_TBL_DATE,
510: ln_government_context_tbl PO_TBL_VARCHAR30,
503: ln_line_type_id_tbl PO_TBL_NUMBER,
504: ln_unit_of_measure_tbl PO_TBL_VARCHAR30,
505: ln_closed_code_tbl PO_TBL_VARCHAR30,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
508: ln_item_revision_tbl PO_TBL_VARCHAR5,
509: ln_expiration_date_tbl PO_TBL_DATE,
510: ln_government_context_tbl PO_TBL_VARCHAR30,
511: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
506: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
507: ln_matching_basis_tbl PO_TBL_VARCHAR30,
508: ln_item_revision_tbl PO_TBL_VARCHAR5,
509: ln_expiration_date_tbl PO_TBL_DATE,
510: ln_government_context_tbl PO_TBL_VARCHAR30,
511: ln_closed_reason_tbl PO_TBL_VARCHAR2000,
512: ln_closed_date_tbl PO_TBL_DATE,
513: ln_closed_by_tbl PO_TBL_NUMBER,
514: ln_from_header_id_tbl PO_TBL_NUMBER,
512: ln_closed_date_tbl PO_TBL_DATE,
513: ln_closed_by_tbl PO_TBL_NUMBER,
514: ln_from_header_id_tbl PO_TBL_NUMBER,
515: ln_from_line_id_tbl PO_TBL_NUMBER,
516: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30,
517:
518: -- attributes read from the header interface record
519: draft_id_tbl PO_TBL_NUMBER,
520: hd_po_header_id_tbl PO_TBL_NUMBER,
521: hd_ship_to_loc_id_tbl PO_TBL_NUMBER,
522: hd_vendor_id_tbl PO_TBL_NUMBER,
523: hd_vendor_site_id_tbl PO_TBL_NUMBER,
524: hd_terms_id_tbl PO_TBL_NUMBER,
525: hd_fob_tbl PO_TBL_VARCHAR30,
526: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
527: hd_freight_term_tbl PO_TBL_VARCHAR30,
528: hd_approved_flag_tbl PO_TBL_VARCHAR1,
529: hd_effective_date_tbl PO_TBL_DATE,
522: hd_vendor_id_tbl PO_TBL_NUMBER,
523: hd_vendor_site_id_tbl PO_TBL_NUMBER,
524: hd_terms_id_tbl PO_TBL_NUMBER,
525: hd_fob_tbl PO_TBL_VARCHAR30,
526: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
527: hd_freight_term_tbl PO_TBL_VARCHAR30,
528: hd_approved_flag_tbl PO_TBL_VARCHAR1,
529: hd_effective_date_tbl PO_TBL_DATE,
530: hd_expiration_date_tbl PO_TBL_DATE,
523: hd_vendor_site_id_tbl PO_TBL_NUMBER,
524: hd_terms_id_tbl PO_TBL_NUMBER,
525: hd_fob_tbl PO_TBL_VARCHAR30,
526: hd_freight_carrier_tbl PO_TBL_VARCHAR30,
527: hd_freight_term_tbl PO_TBL_VARCHAR30,
528: hd_approved_flag_tbl PO_TBL_VARCHAR1,
529: hd_effective_date_tbl PO_TBL_DATE,
530: hd_expiration_date_tbl PO_TBL_DATE,
531: hd_style_id_tbl PO_TBL_NUMBER,
555: ln_list_price_per_unit_tbl PO_TBL_NUMBER,
556: ln_market_price_tbl PO_TBL_NUMBER,
557: ln_un_number_id_tbl PO_TBL_NUMBER,
558: ln_hazard_class_id_tbl PO_TBL_NUMBER,
559: ln_qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
560: ln_weight_uom_code_tbl PO_TBL_VARCHAR5,
561: ln_volume_uom_code_tbl PO_TBL_VARCHAR5,
562: ln_template_id_tbl PO_TBL_NUMBER,
563: ln_category_id_tbl PO_TBL_NUMBER,
587: deliver_to_loc_tbl PO_TBL_VARCHAR100,
588: deliver_to_loc_id_tbl PO_TBL_NUMBER,
589: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
590: deliver_to_person_id_tbl PO_TBL_NUMBER,
591: dest_type_tbl PO_TBL_VARCHAR30,
592: dest_type_code_tbl PO_TBL_VARCHAR30,
593: dest_org_tbl PO_TBL_VARCHAR100,
594: dest_org_id_tbl PO_TBL_NUMBER,
595: wip_entity_tbl PO_TBL_VARCHAR2000,
588: deliver_to_loc_id_tbl PO_TBL_NUMBER,
589: deliver_to_person_name_tbl PO_TBL_VARCHAR2000,
590: deliver_to_person_id_tbl PO_TBL_NUMBER,
591: dest_type_tbl PO_TBL_VARCHAR30,
592: dest_type_code_tbl PO_TBL_VARCHAR30,
593: dest_org_tbl PO_TBL_VARCHAR100,
594: dest_org_id_tbl PO_TBL_NUMBER,
595: wip_entity_tbl PO_TBL_VARCHAR2000,
596: wip_entity_id_tbl PO_TBL_NUMBER,
593: dest_org_tbl PO_TBL_VARCHAR100,
594: dest_org_id_tbl PO_TBL_NUMBER,
595: wip_entity_tbl PO_TBL_VARCHAR2000,
596: wip_entity_id_tbl PO_TBL_NUMBER,
597: wip_line_code_tbl PO_TBL_VARCHAR30,
598: wip_line_id_tbl PO_TBL_NUMBER,
599: bom_resource_code_tbl PO_TBL_VARCHAR30,
600: bom_resource_id_tbl PO_TBL_NUMBER,
601: charge_account_tbl PO_TBL_VARCHAR2000,
595: wip_entity_tbl PO_TBL_VARCHAR2000,
596: wip_entity_id_tbl PO_TBL_NUMBER,
597: wip_line_code_tbl PO_TBL_VARCHAR30,
598: wip_line_id_tbl PO_TBL_NUMBER,
599: bom_resource_code_tbl PO_TBL_VARCHAR30,
600: bom_resource_id_tbl PO_TBL_NUMBER,
601: charge_account_tbl PO_TBL_VARCHAR2000,
602: charge_account_id_tbl PO_TBL_NUMBER,
603: set_of_books_id_tbl PO_TBL_NUMBER,
601: charge_account_tbl PO_TBL_VARCHAR2000,
602: charge_account_id_tbl PO_TBL_NUMBER,
603: set_of_books_id_tbl PO_TBL_NUMBER,
604: dest_charge_account_id_tbl PO_TBL_NUMBER,
605: project_accounting_context_tbl PO_TBL_VARCHAR30,
606: award_num_tbl PO_TBL_VARCHAR30,
607: award_id_tbl PO_TBL_NUMBER,
608: project_tbl PO_TBL_VARCHAR30,
609: project_id_tbl PO_TBL_NUMBER,
602: charge_account_id_tbl PO_TBL_NUMBER,
603: set_of_books_id_tbl PO_TBL_NUMBER,
604: dest_charge_account_id_tbl PO_TBL_NUMBER,
605: project_accounting_context_tbl PO_TBL_VARCHAR30,
606: award_num_tbl PO_TBL_VARCHAR30,
607: award_id_tbl PO_TBL_NUMBER,
608: project_tbl PO_TBL_VARCHAR30,
609: project_id_tbl PO_TBL_NUMBER,
610: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
604: dest_charge_account_id_tbl PO_TBL_NUMBER,
605: project_accounting_context_tbl PO_TBL_VARCHAR30,
606: award_num_tbl PO_TBL_VARCHAR30,
607: award_id_tbl PO_TBL_NUMBER,
608: project_tbl PO_TBL_VARCHAR30,
609: project_id_tbl PO_TBL_NUMBER,
610: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
611: task_id_tbl PO_TBL_NUMBER,
612: expenditure_tbl PO_TBL_VARCHAR100,
609: project_id_tbl PO_TBL_NUMBER,
610: task_tbl PO_TBL_VARCHAR2000, --- Bug#16505809
611: task_id_tbl PO_TBL_NUMBER,
612: expenditure_tbl PO_TBL_VARCHAR100,
613: expenditure_type_tbl PO_TBL_VARCHAR30,
614: expenditure_org_tbl PO_TBL_VARCHAR100,
615: expenditure_org_id_tbl PO_TBL_NUMBER,
616: expenditure_item_date_tbl PO_TBL_DATE,
617: end_item_unit_number_tbl PO_TBL_VARCHAR30,
613: expenditure_type_tbl PO_TBL_VARCHAR30,
614: expenditure_org_tbl PO_TBL_VARCHAR100,
615: expenditure_org_id_tbl PO_TBL_NUMBER,
616: expenditure_item_date_tbl PO_TBL_DATE,
617: end_item_unit_number_tbl PO_TBL_VARCHAR30,
618: dest_context_tbl PO_TBL_VARCHAR30,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,
621: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
614: expenditure_org_tbl PO_TBL_VARCHAR100,
615: expenditure_org_id_tbl PO_TBL_NUMBER,
616: expenditure_item_date_tbl PO_TBL_DATE,
617: end_item_unit_number_tbl PO_TBL_VARCHAR30,
618: dest_context_tbl PO_TBL_VARCHAR30,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,
621: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
622: variance_account_id_tbl PO_TBL_NUMBER,
617: end_item_unit_number_tbl PO_TBL_VARCHAR30,
618: dest_context_tbl PO_TBL_VARCHAR30,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,
621: gl_encumbered_period_tbl PO_TBL_VARCHAR30,
622: variance_account_id_tbl PO_TBL_NUMBER,
623: accrual_account_id_tbl PO_TBL_NUMBER,
624: budget_account_id_tbl PO_TBL_NUMBER,
625: dest_variance_account_id_tbl PO_TBL_NUMBER,
622: variance_account_id_tbl PO_TBL_NUMBER,
623: accrual_account_id_tbl PO_TBL_NUMBER,
624: budget_account_id_tbl PO_TBL_NUMBER,
625: dest_variance_account_id_tbl PO_TBL_NUMBER,
626: dest_subinventory_tbl PO_TBL_VARCHAR30,
627: amount_ordered_tbl PO_TBL_NUMBER,
628: quantity_ordered_tbl PO_TBL_NUMBER,
629: wip_rep_schedule_id_tbl PO_TBL_NUMBER,
630: wip_operation_seq_num_tbl PO_TBL_NUMBER,
635: recoverable_tax_tbl PO_TBL_NUMBER,
636: nonrecoverable_tax_tbl PO_TBL_NUMBER,
637: oke_contract_line_id_tbl PO_TBL_NUMBER,
638: oke_cont_deliverable_id_tbl PO_TBL_NUMBER,
639: account_segment1_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
636: nonrecoverable_tax_tbl PO_TBL_NUMBER,
637: oke_contract_line_id_tbl PO_TBL_NUMBER,
638: oke_cont_deliverable_id_tbl PO_TBL_NUMBER,
639: account_segment1_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
637: oke_contract_line_id_tbl PO_TBL_NUMBER,
638: oke_cont_deliverable_id_tbl PO_TBL_NUMBER,
639: account_segment1_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
638: oke_cont_deliverable_id_tbl PO_TBL_NUMBER,
639: account_segment1_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
639: account_segment1_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
640: account_segment2_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
641: account_segment3_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
642: account_segment4_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
643: account_segment5_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
644: account_segment6_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
645: account_segment7_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
646: account_segment8_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
647: account_segment9_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
648: account_segment10_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
649: account_segment11_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
650: account_segment12_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
651: account_segment13_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
652: account_segment14_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
653: account_segment15_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
654: account_segment16_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
655: account_segment17_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
656: account_segment18_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
657: account_segment19_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
658: account_segment20_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
659: account_segment21_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
660: account_segment22_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
668: account_segment30_tbl PO_TBL_VARCHAR30,
661: account_segment23_tbl PO_TBL_VARCHAR30,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
668: account_segment30_tbl PO_TBL_VARCHAR30,
669: dist_attribute1_tbl PO_TBL_VARCHAR2000,
662: account_segment24_tbl PO_TBL_VARCHAR30,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
668: account_segment30_tbl PO_TBL_VARCHAR30,
669: dist_attribute1_tbl PO_TBL_VARCHAR2000,
670: dist_attribute2_tbl PO_TBL_VARCHAR2000,
663: account_segment25_tbl PO_TBL_VARCHAR30,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
668: account_segment30_tbl PO_TBL_VARCHAR30,
669: dist_attribute1_tbl PO_TBL_VARCHAR2000,
670: dist_attribute2_tbl PO_TBL_VARCHAR2000,
671: dist_attribute3_tbl PO_TBL_VARCHAR2000,
664: account_segment26_tbl PO_TBL_VARCHAR30,
665: account_segment27_tbl PO_TBL_VARCHAR30,
666: account_segment28_tbl PO_TBL_VARCHAR30,
667: account_segment29_tbl PO_TBL_VARCHAR30,
668: account_segment30_tbl PO_TBL_VARCHAR30,
669: dist_attribute1_tbl PO_TBL_VARCHAR2000,
670: dist_attribute2_tbl PO_TBL_VARCHAR2000,
671: dist_attribute3_tbl PO_TBL_VARCHAR2000,
672: dist_attribute4_tbl PO_TBL_VARCHAR2000,
693: program_id_tbl PO_TBL_NUMBER,
694: program_update_date_tbl PO_TBL_DATE,
695:
696: -- attributes exist in txn table but not in interface table
697: tax_attribute_update_code_tbl PO_TBL_VARCHAR30,
698: award_set_id_tbl PO_TBL_NUMBER,
699: org_id_tbl PO_TBL_NUMBER,
700: distribution_type_tbl PO_TBL_VARCHAR25,
701: req_distribution_id_tbl PO_TBL_NUMBER,
702:
703: -- attributes read from line location record
704: loc_ship_to_org_id_tbl PO_TBL_NUMBER,
705: loc_line_loc_id_tbl PO_TBL_NUMBER,
706: loc_shipment_type_tbl PO_TBL_VARCHAR30,
707: loc_txn_flow_header_id_tbl PO_TBL_NUMBER,
708: loc_accrue_on_receipt_flag_tbl PO_TBL_VARCHAR1,
709: loc_need_by_date_tbl PO_TBL_DATE,
710: loc_promised_date_tbl PO_TBL_DATE,
726: loc_attribute14_tbl PO_TBL_VARCHAR2000,
727: loc_attribute15_tbl PO_TBL_VARCHAR2000,
728:
729: -- attributes read from line record
730: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_id_tbl PO_TBL_NUMBER,
727: loc_attribute15_tbl PO_TBL_VARCHAR2000,
728:
729: -- attributes read from line record
730: ln_order_type_lookup_code_tbl PO_TBL_VARCHAR30,
731: ln_purchase_basis_tbl PO_TBL_VARCHAR30,
732: ln_item_id_tbl PO_TBL_NUMBER,
733: ln_category_id_tbl PO_TBL_NUMBER,
734: ln_line_type_id_tbl PO_TBL_NUMBER,
735: ln_po_line_id_tbl PO_TBL_NUMBER,
754: hd_agent_id_tbl PO_TBL_NUMBER,
755: hd_po_header_id_tbl PO_TBL_NUMBER,
756: hd_rate_date_tbl PO_TBL_DATE,
757: hd_rate_tbl PO_TBL_NUMBER,
758: hd_type_lookup_code_tbl PO_TBL_VARCHAR30,
759: hd_vendor_id_tbl PO_TBL_NUMBER,
760: hd_attribute1_tbl PO_TBL_VARCHAR2000,
761: hd_attribute2_tbl PO_TBL_VARCHAR2000,
762: hd_attribute3_tbl PO_TBL_VARCHAR2000,
783: rec_count NUMBER,
784:
785: -- CLM specific attributes
786: clm_misc_loa PO_TBL_VARCHAR2000,
787: clm_defence_funding PO_TBL_VARCHAR30,
788: clm_fms_case_number PO_TBL_VARCHAR2000,
789: clm_agency_acct_identifier PO_TBL_VARCHAR100
790: -- ATTENTION: If you are adding new attributes to this record type, see
791: -- the message above first.
801: intf_price_diff_id_tbl PO_TBL_NUMBER,
802: intf_line_id_tbl PO_TBL_NUMBER,
803: intf_header_id_tbl PO_TBL_NUMBER,
804: price_diff_num_tbl PO_TBL_NUMBER,
805: price_type_tbl PO_TBL_VARCHAR30,
806: entity_type_tbl PO_TBL_VARCHAR30,
807: entity_id_tbl PO_TBL_NUMBER,
808: multiplier_tbl PO_TBL_NUMBER,
809: min_multiplier_tbl PO_TBL_NUMBER,
802: intf_line_id_tbl PO_TBL_NUMBER,
803: intf_header_id_tbl PO_TBL_NUMBER,
804: price_diff_num_tbl PO_TBL_NUMBER,
805: price_type_tbl PO_TBL_VARCHAR30,
806: entity_type_tbl PO_TBL_VARCHAR30,
807: entity_id_tbl PO_TBL_NUMBER,
808: multiplier_tbl PO_TBL_NUMBER,
809: min_multiplier_tbl PO_TBL_NUMBER,
810: max_multiplier_tbl PO_TBL_NUMBER,
808: multiplier_tbl PO_TBL_NUMBER,
809: min_multiplier_tbl PO_TBL_NUMBER,
810: max_multiplier_tbl PO_TBL_NUMBER,
811: enabled_flag_tbl PO_TBL_VARCHAR1,
812: process_status_tbl PO_TBL_VARCHAR30,
813:
814: -- attribute read from line location
815: loc_line_loc_id_tbl PO_TBL_NUMBER,
816: