[Home] [Help]
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,
212: template_id_tbl PO_TBL_NUMBER,
213: item_desc_tbl PO_TBL_VARCHAR2000,
216: from_header_id_tbl PO_TBL_NUMBER,
217: from_line_id_tbl PO_TBL_NUMBER,
218: list_price_per_unit_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,
218: list_price_per_unit_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,
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,
230: effective_date_tbl PO_TBL_DATE,
231: expiration_date_tbl PO_TBL_DATE,
232: attribute14_tbl PO_TBL_VARCHAR2000,
233: price_update_tolerance_tbl PO_TBL_NUMBER,
230: effective_date_tbl PO_TBL_DATE,
231: expiration_date_tbl PO_TBL_DATE,
232: attribute14_tbl PO_TBL_VARCHAR2000,
233: price_update_tolerance_tbl PO_TBL_NUMBER,
234: line_loc_populated_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,
231: expiration_date_tbl PO_TBL_DATE,
232: attribute14_tbl PO_TBL_VARCHAR2000,
233: price_update_tolerance_tbl PO_TBL_NUMBER,
234: line_loc_populated_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,
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,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_tbl PO_TBL_VARCHAR1,
264: clm_base_line_num_tbl PO_TBL_NUMBER,
265: clm_option_num_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,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_tbl PO_TBL_VARCHAR1,
264: clm_base_line_num_tbl PO_TBL_NUMBER,
265: clm_option_num_tbl PO_TBL_NUMBER,
266: clm_option_from_date_tbl PO_TBL_DATE,
259: requisition_line_id_tbl PO_TBL_NUMBER,
260: group_line_id_tbl PO_TBL_NUMBER,
261: line_num_display_tbl PO_TBL_VARCHAR100,
262: clm_info_flag_tbl PO_TBL_VARCHAR1,
263: clm_option_indicator_tbl PO_TBL_VARCHAR1,
264: clm_base_line_num_tbl PO_TBL_NUMBER,
265: clm_option_num_tbl PO_TBL_NUMBER,
266: clm_option_from_date_tbl PO_TBL_DATE,
267: clm_option_to_date_tbl PO_TBL_DATE,
264: clm_base_line_num_tbl PO_TBL_NUMBER,
265: clm_option_num_tbl PO_TBL_NUMBER,
266: clm_option_from_date_tbl PO_TBL_DATE,
267: clm_option_to_date_tbl PO_TBL_DATE,
268: clm_funded_flag_tbl PO_TBL_VARCHAR1,
269: cost_constraint_tbl PO_TBL_VARCHAR240,
270: contract_type_tbl po_tbl_varchar240,
271: clm_idc_type_tbl po_tbl_varchar240,
272: need_by_date_tbl PO_TBL_DATE,
271: clm_idc_type_tbl po_tbl_varchar240,
272: need_by_date_tbl PO_TBL_DATE,
273: transaction_reason_code_tbl po_tbl_varchar240,
274: retainage_rate_tbl po_tbl_number,
275: consigned_flag_tbl po_tbl_varchar1,
276: oke_contract_version_id_tbl po_tbl_number,
277: oke_contract_header_id_tbl po_tbl_number,
278: note_to_vendor_tbl po_tbl_varchar2000,
279: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
288: progress_payment_rate_tbl po_tbl_number,
289: recoupment_rate_tbl po_tbl_number,
290: catalog_name_tbl po_tbl_varchar2000,
291: firm_status_lookup_code_tbl po_tbl_varchar240,
292: drop_ship_flag_tbl po_tbl_varchar1,
293: line_ship_to_org_id_tbl po_tbl_number,
294: line_ship_to_loc_id_tbl po_tbl_number,
295:
296:
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,
316: taxable_flag_tbl po_tbl_varchar1,
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,
316: taxable_flag_tbl po_tbl_varchar1,
317: tax_name_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:
320: -- attributes read from the header interface record
325: hd_vendor_site_id_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,
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,
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,
347: it_secondary_uom_code_tbl po_tbl_varchar30,
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,
347: it_secondary_uom_code_tbl po_tbl_varchar30,
348: it_grade_control_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
352: rc_enforce_shipto_loc_code_tbl po_tbl_varchar30,
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,
357: rc_days_early_recpt_tbl po_tbl_number,
362:
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,
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,
372: receipt_required_flag_tbl po_tbl_varchar1,
373: note_to_receiver_tbl PO_TBL_VARCHAR2000,
374: vmi_flag_tbl po_tbl_varchar1,
375: promised_date_tbl PO_TBL_DATE,
376: has_advance_flag_tbl po_tbl_varchar1,
370: tax_code_id_tbl po_tbl_number,
371: txn_flow_header_id_tbl PO_TBL_NUMBER,
372: receipt_required_flag_tbl po_tbl_varchar1,
373: note_to_receiver_tbl PO_TBL_VARCHAR2000,
374: vmi_flag_tbl po_tbl_varchar1,
375: promised_date_tbl PO_TBL_DATE,
376: has_advance_flag_tbl po_tbl_varchar1,
377: advance_amount_tbl po_tbl_number,
378: poll_intf_pop_flag_tbl po_tbl_varchar1,
372: receipt_required_flag_tbl po_tbl_varchar1,
373: note_to_receiver_tbl PO_TBL_VARCHAR2000,
374: vmi_flag_tbl po_tbl_varchar1,
375: promised_date_tbl PO_TBL_DATE,
376: has_advance_flag_tbl po_tbl_varchar1,
377: advance_amount_tbl po_tbl_number,
378: poll_intf_pop_flag_tbl po_tbl_varchar1,
379: price_discount_tbl PO_TBL_NUMBER,
380: terms_id_tbl PO_TBL_NUMBER,
374: vmi_flag_tbl po_tbl_varchar1,
375: promised_date_tbl PO_TBL_DATE,
376: has_advance_flag_tbl po_tbl_varchar1,
377: advance_amount_tbl po_tbl_number,
378: poll_intf_pop_flag_tbl po_tbl_varchar1,
379: price_discount_tbl PO_TBL_NUMBER,
380: terms_id_tbl PO_TBL_NUMBER,
381: Shipment_Type_tbl po_tbl_varchar100,
382: rate_for_req_fields_tbl po_tbl_number,
377: advance_amount_tbl po_tbl_number,
378: poll_intf_pop_flag_tbl po_tbl_varchar1,
379: price_discount_tbl PO_TBL_NUMBER,
380: terms_id_tbl PO_TBL_NUMBER,
381: Shipment_Type_tbl po_tbl_varchar100,
382: rate_for_req_fields_tbl po_tbl_number,
383: line_loc_id_tbl po_tbl_number,
384:
385: -- attributes added for uniqueness checking
384:
385: -- attributes added for uniqueness checking
386: origin_line_num_tbl PO_TBL_NUMBER,
387: group_num_tbl PO_TBL_NUMBER,
388: match_line_found_tbl PO_TBL_VARCHAR1,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
391: -- attributes added for processing purpose
392: error_flag_tbl PO_TBL_VARCHAR1,
385: -- attributes added for uniqueness checking
386: origin_line_num_tbl PO_TBL_NUMBER,
387: group_num_tbl PO_TBL_NUMBER,
388: match_line_found_tbl PO_TBL_VARCHAR1,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
391: -- attributes added for processing purpose
392: error_flag_tbl PO_TBL_VARCHAR1,
393: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
388: match_line_found_tbl PO_TBL_VARCHAR1,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
391: -- attributes added for processing purpose
392: error_flag_tbl PO_TBL_VARCHAR1,
393: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
394: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
395: rec_count NUMBER,
396: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
389: line_num_unique_tbl PO_TBL_VARCHAR1,
390:
391: -- attributes added for processing purpose
392: error_flag_tbl PO_TBL_VARCHAR1,
393: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
394: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
395: rec_count NUMBER,
396: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
397:
390:
391: -- attributes added for processing purpose
392: error_flag_tbl PO_TBL_VARCHAR1,
393: need_to_reject_flag_tbl PO_TBL_VARCHAR1,
394: allow_desc_update_flag_tbl PO_TBL_VARCHAR1,
395: rec_count NUMBER,
396: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE,
397:
398: -- CLM specific attributes
407: clm_total_amount_ordered_tbl PO_TBL_NUMBER,
408: clm_total_quantity_ordered_tbl PO_TBL_NUMBER,
409: clm_period_perf_end_date_tbl PO_TBL_DATE,
410: clm_period_perf_start_date_tbl PO_TBL_DATE,
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,
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,
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,
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,
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,
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,
449: qty_rcv_tolerance_tbl PO_TBL_NUMBER,
450: qty_rcv_exception_code_tbl PO_TBL_VARCHAR30,
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,
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,
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,
456: invoice_close_tolerance_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,
460: fob_tbl PO_TBL_VARCHAR30,
461: freight_carrier_tbl PO_TBL_VARCHAR30,
462: freight_term_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,
479:
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,
532:
563: ln_category_id_tbl PO_TBL_NUMBER,
564: line_ref_index_tbl PO_TBL_NUMBER,
565:
566: -- attributes added for processing purpose
567: shipment_num_unique_tbl PO_TBL_VARCHAR1,
568: error_flag_tbl PO_TBL_VARCHAR1,
569: rec_count NUMBER,
570: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
571:
564: line_ref_index_tbl PO_TBL_NUMBER,
565:
566: -- attributes added for processing purpose
567: shipment_num_unique_tbl PO_TBL_VARCHAR1,
568: error_flag_tbl PO_TBL_VARCHAR1,
569: rec_count NUMBER,
570: intf_id_index_tbl DBMS_SQL.NUMBER_TABLE
571:
572: -- ATTENTION: If you are adding new attributes to this record type, see
583: intf_line_id_tbl PO_TBL_NUMBER,
584: intf_line_loc_id_tbl PO_TBL_NUMBER,
585: po_dist_id_tbl PO_TBL_NUMBER,
586: dist_num_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,
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,
597: wip_line_code_tbl PO_TBL_VARCHAR30,
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,
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,
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,
618: dest_context_tbl PO_TBL_VARCHAR30,
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,
623: accrual_account_id_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,
631: wip_resource_seq_num_tbl PO_TBL_NUMBER,
632: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
633: recovery_rate_tbl PO_TBL_NUMBER,
634: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
635: recoverable_tax_tbl PO_TBL_NUMBER,
636: nonrecoverable_tax_tbl PO_TBL_NUMBER,
630: wip_operation_seq_num_tbl PO_TBL_NUMBER,
631: wip_resource_seq_num_tbl PO_TBL_NUMBER,
632: prevent_encumbrance_flag_tbl PO_TBL_VARCHAR1,
633: recovery_rate_tbl PO_TBL_NUMBER,
634: tax_recovery_override_flag_tbl PO_TBL_VARCHAR1,
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,
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,
711: loc_price_override_tbl PO_TBL_NUMBER,
712: loc_outsourced_assembly_tbl PO_TBL_NUMBER,
775:
776: -- attributes added for processing
777: ship_to_ou_id_tbl PO_TBL_NUMBER,
778: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
779: item_status_tbl PO_TBL_VARCHAR1,
780: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
781: dist_num_unique_tbl PO_TBL_VARCHAR1,
782: error_flag_tbl PO_TBL_VARCHAR1,
783: rec_count NUMBER,
776: -- attributes added for processing
777: ship_to_ou_id_tbl PO_TBL_NUMBER,
778: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
779: item_status_tbl PO_TBL_VARCHAR1,
780: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
781: dist_num_unique_tbl PO_TBL_VARCHAR1,
782: error_flag_tbl PO_TBL_VARCHAR1,
783: rec_count NUMBER,
784:
777: ship_to_ou_id_tbl PO_TBL_NUMBER,
778: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
779: item_status_tbl PO_TBL_VARCHAR1,
780: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
781: dist_num_unique_tbl PO_TBL_VARCHAR1,
782: error_flag_tbl PO_TBL_VARCHAR1,
783: rec_count NUMBER,
784:
785: -- CLM specific attributes
778: ship_to_ou_coa_id_tbl PO_TBL_NUMBER,
779: item_status_tbl PO_TBL_VARCHAR1,
780: gms_txn_required_flag_tbl PO_TBL_VARCHAR1,
781: dist_num_unique_tbl PO_TBL_VARCHAR1,
782: error_flag_tbl PO_TBL_VARCHAR1,
783: rec_count NUMBER,
784:
785: -- CLM specific attributes
786: clm_misc_loa PO_TBL_VARCHAR2000,
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.
792: );
793:
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,
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,
821: draft_id_tbl PO_TBL_NUMBER,
822: hd_style_id_tbl PO_TBL_NUMBER,
823:
824: -- attributes added for processing
825: error_flag_tbl PO_TBL_VARCHAR1,
826: price_diff_num_unique_tbl PO_TBL_VARCHAR1,
827: rec_count NUMBER
828:
829: -- ATTENTION: If you are adding new attributes to this record type, see
822: hd_style_id_tbl PO_TBL_NUMBER,
823:
824: -- attributes added for processing
825: error_flag_tbl PO_TBL_VARCHAR1,
826: price_diff_num_unique_tbl PO_TBL_VARCHAR1,
827: rec_count NUMBER
828:
829: -- ATTENTION: If you are adding new attributes to this record type, see
830: -- the message above first.
850:
851: -- attributes added for processing purpose
852: attribute_values_id_tbl PO_TBL_NUMBER,
853: source_tbl DBMS_SQL.VARCHAR2_TABLE,
854: error_flag_tbl PO_TBL_VARCHAR1,
855:
856: rec_count NUMBER
857:
858: -- ATTENTION: If you are adding new attributes to this record type, see
881: -- attribute from headers
882: draft_id_tbl PO_TBL_NUMBER,
883:
884: -- attributes added for processing purpose
885: error_flag_tbl PO_TBL_VARCHAR1,
886: attribute_values_tlp_id_tbl PO_TBL_NUMBER,
887: source_tbl DBMS_SQL.VARCHAR2_TABLE,
888:
889: rec_count NUMBER