eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOCREATE_TYPES dependencies on PO_TBL_DATE

Line 230: effective_date_tbl PO_TBL_DATE,

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,
234: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,

Line 231: expiration_date_tbl PO_TBL_DATE,

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,
234: line_loc_populated_flag_tbl PO_TBL_VARCHAR1,
235: negotiated_flag_tbl PO_TBL_VARCHAR1,

Line 248: closed_date_tbl PO_TBL_DATE,

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,
251: weight_uom_code_tbl PO_TBL_VARCHAR5,
252: volume_uom_code_tbl PO_TBL_VARCHAR5,

Line 266: clm_option_from_date_tbl PO_TBL_DATE,

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,
268: clm_funded_flag_tbl PO_TBL_VARCHAR1,
269: cost_constraint_tbl PO_TBL_VARCHAR240,
270: contract_type_tbl po_tbl_varchar240,

Line 267: clm_option_to_date_tbl PO_TBL_DATE,

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,
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,

Line 272: need_by_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,
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,

Line 299: last_update_date_tbl PO_TBL_DATE,

295:
296:
297: -- standard who columns
298: last_updated_by_tbl PO_TBL_NUMBER,
299: last_update_date_tbl PO_TBL_DATE,
300: last_update_login_tbl PO_TBL_NUMBER,
301: creation_date_tbl PO_TBL_DATE,
302: created_by_tbl PO_TBL_NUMBER,
303: request_id_tbl PO_TBL_NUMBER,

Line 301: creation_date_tbl PO_TBL_DATE,

297: -- standard who columns
298: last_updated_by_tbl PO_TBL_NUMBER,
299: last_update_date_tbl PO_TBL_DATE,
300: last_update_login_tbl PO_TBL_NUMBER,
301: creation_date_tbl PO_TBL_DATE,
302: created_by_tbl PO_TBL_NUMBER,
303: request_id_tbl PO_TBL_NUMBER,
304: program_application_id_tbl PO_TBL_NUMBER,
305: program_id_tbl PO_TBL_NUMBER,

Line 306: program_update_date_tbl PO_TBL_DATE,

302: created_by_tbl PO_TBL_NUMBER,
303: request_id_tbl PO_TBL_NUMBER,
304: program_application_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,

Line 327: hd_start_date_tbl PO_TBL_DATE,

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,
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,

Line 328: hd_end_date_tbl PO_TBL_DATE,

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,
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,

Line 334: hd_rate_date_tbl PO_TBL_DATE,

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

Line 375: promised_date_tbl PO_TBL_DATE,

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,
379: price_discount_tbl PO_TBL_NUMBER,

Line 409: clm_period_perf_end_date_tbl PO_TBL_DATE,

405: clm_min_order_quantity_tbl PO_TBL_NUMBER,
406: clm_max_order_quantity_tbl PO_TBL_NUMBER,
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

Line 410: clm_period_perf_start_date_tbl PO_TBL_DATE,

406: clm_max_order_quantity_tbl PO_TBL_NUMBER,
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,

Line 412: clm_exercised_date_tbl PO_TBL_DATE, -- Bug 9960752

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,
416: clm_delivery_period_tbl PO_TBL_NUMBER,

Line 463: need_by_date_tbl PO_TBL_DATE,

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,
467: end_date_tbl PO_TBL_DATE,

Line 464: promised_date_tbl PO_TBL_DATE,

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,
467: end_date_tbl PO_TBL_DATE,
468: note_to_receiver_tbl PO_TBL_VARCHAR2000,

Line 466: start_date_tbl PO_TBL_DATE,

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,
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,

Line 467: end_date_tbl PO_TBL_DATE,

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,
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,

Line 488: last_update_date_tbl PO_TBL_DATE,

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,
489: last_update_login_tbl PO_TBL_NUMBER,
490: creation_date_tbl PO_TBL_DATE,
491: created_by_tbl PO_TBL_NUMBER,
492: request_id_tbl PO_TBL_NUMBER,

Line 490: creation_date_tbl PO_TBL_DATE,

486: -- standard who columns
487: last_updated_by_tbl PO_TBL_NUMBER,
488: last_update_date_tbl PO_TBL_DATE,
489: last_update_login_tbl PO_TBL_NUMBER,
490: creation_date_tbl PO_TBL_DATE,
491: created_by_tbl PO_TBL_NUMBER,
492: request_id_tbl PO_TBL_NUMBER,
493: program_application_id_tbl PO_TBL_NUMBER,
494: program_id_tbl PO_TBL_NUMBER,

Line 495: program_update_date_tbl PO_TBL_DATE,

491: created_by_tbl PO_TBL_NUMBER,
492: request_id_tbl PO_TBL_NUMBER,
493: program_application_id_tbl PO_TBL_NUMBER,
494: program_id_tbl PO_TBL_NUMBER,
495: program_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,

Line 509: ln_expiration_date_tbl PO_TBL_DATE,

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,
512: ln_closed_date_tbl PO_TBL_DATE,
513: ln_closed_by_tbl PO_TBL_NUMBER,

Line 512: ln_closed_date_tbl PO_TBL_DATE,

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,
515: ln_from_line_id_tbl PO_TBL_NUMBER,
516: ln_price_break_lookup_code_tbl PO_TBL_VARCHAR30,

Line 529: hd_effective_date_tbl PO_TBL_DATE,

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:
533: -- attributes added for item processing(read from line)

Line 530: hd_expiration_date_tbl PO_TBL_DATE,

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:
533: -- attributes added for item processing(read from line)
534: --ln_qty_rcv_tolerance_tbl PO_TBL_NUMBER,

Line 616: expenditure_item_date_tbl PO_TBL_DATE,

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,
619: encumbered_flag_tbl PO_TBL_VARCHAR1,
620: gl_encumbered_date_tbl PO_TBL_DATE,

Line 620: gl_encumbered_date_tbl PO_TBL_DATE,

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,
624: budget_account_id_tbl PO_TBL_NUMBER,

Line 687: last_update_date_tbl PO_TBL_DATE,

683: dist_attribute15_tbl PO_TBL_VARCHAR2000,
684:
685: -- standard who columns
686: last_updated_by_tbl PO_TBL_NUMBER,
687: last_update_date_tbl PO_TBL_DATE,
688: last_update_login_tbl PO_TBL_NUMBER,
689: creation_date_tbl PO_TBL_DATE,
690: created_by_tbl PO_TBL_NUMBER,
691: request_id_tbl PO_TBL_NUMBER,

Line 689: creation_date_tbl PO_TBL_DATE,

685: -- standard who columns
686: last_updated_by_tbl PO_TBL_NUMBER,
687: last_update_date_tbl PO_TBL_DATE,
688: last_update_login_tbl PO_TBL_NUMBER,
689: creation_date_tbl PO_TBL_DATE,
690: created_by_tbl PO_TBL_NUMBER,
691: request_id_tbl PO_TBL_NUMBER,
692: program_application_id_tbl PO_TBL_NUMBER,
693: program_id_tbl PO_TBL_NUMBER,

Line 694: program_update_date_tbl PO_TBL_DATE,

690: created_by_tbl PO_TBL_NUMBER,
691: request_id_tbl PO_TBL_NUMBER,
692: program_application_id_tbl PO_TBL_NUMBER,
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,

Line 709: loc_need_by_date_tbl PO_TBL_DATE,

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,
713: loc_attribute1_tbl PO_TBL_VARCHAR2000,

Line 710: loc_promised_date_tbl PO_TBL_DATE,

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,
713: loc_attribute1_tbl PO_TBL_VARCHAR2000,
714: loc_attribute2_tbl PO_TBL_VARCHAR2000,

Line 756: hd_rate_date_tbl PO_TBL_DATE,

752: -- attributes read from header record
753: draft_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,