VIEW: APPS.POA_EDW_AGREEMENT_LINES_FCV

Source

View Text - Preformatted

SELECT seq_id, view_id, agree_ln_inst_pk, instance_fk, buyer_fk, approver_fk, item_revision_fk, supplier_site_fk, operating_unit_fk, po_create_date_fk, lne_creat_date_fk, approved_date_fk, revised_date_fk, start_date_fk, end_date_fk, accpt_due_date_fk, txn_cur_date_fk, po_print_date_fk, ap_terms_fk, po_closed_fk, po_type_fk, ship_via_fk, fob_fk, freight_terms_fk, txn_reason_fk, price_type_fk, price_break_fk, accpt_required_fk, frozen_fk, approved_fk, user_hold_fk, confirm_order_fk, supply_agree_fk, neg_by_prepare_fk, cancelled_fk, lne_closed_fk, edi_processed_fk, base_uom_fk, txn_uom_fk, bill_location_fk, ship_location_fk, sup_site_geog_fk, txn_cur_code_fk, txn_cur_rate_type, po_line_type_fk, contract_effective_fk, supplier_item_num_fk , amt_agreed_t, amt_agreed_g , qty_ordered_t, qty_min_order_t, qty_max_order_t, market_price_t, market_price_g , price_limit_t, price_limit_g , list_price_t, list_price_g , unit_price_t, unit_price_g , amt_min_release_t, amt_min_release_g, qty_agreed_t, qty_released_t, amt_released_t, amt_released_g, num_days_create_to_app, num_days_app_to_send, num_days_app_send_to_accpt, item_id, item_description, po_supplier_note, comments, receiver_note, po_header_id, po_line_id, cancel_reason, last_update_date, DUNS_FK, UNSPSC_FK, SIC_CODE_FK, Collection_Status, NULL user_attribute1, NULL user_attribute2, NULL user_attribute3, NULL user_attribute4, NULL user_attribute5, NULL user_attribute6, NULL user_attribute7, NULL user_attribute8, NULL user_attribute9, NULL user_attribute10, NULL user_attribute11, NULL user_attribute12, NULL user_attribute13, NULL user_attribute14, NULL user_attribute15, to_number(NULL) user_measure1, to_number(NULL) user_measure2, to_number(NULL) user_measure3, to_number(NULL) user_measure4, to_number(NULL) user_measure5, 'NA_EDW' user_fk1, 'NA_EDW' user_fk2, 'NA_EDW' user_fk3, 'NA_EDW' user_fk4, 'NA_EDW' user_fk5 FROM poabv_edw_agreement_lines_fcv

View Text - HTML Formatted

SELECT SEQ_ID
, VIEW_ID
, AGREE_LN_INST_PK
, INSTANCE_FK
, BUYER_FK
, APPROVER_FK
, ITEM_REVISION_FK
, SUPPLIER_SITE_FK
, OPERATING_UNIT_FK
, PO_CREATE_DATE_FK
, LNE_CREAT_DATE_FK
, APPROVED_DATE_FK
, REVISED_DATE_FK
, START_DATE_FK
, END_DATE_FK
, ACCPT_DUE_DATE_FK
, TXN_CUR_DATE_FK
, PO_PRINT_DATE_FK
, AP_TERMS_FK
, PO_CLOSED_FK
, PO_TYPE_FK
, SHIP_VIA_FK
, FOB_FK
, FREIGHT_TERMS_FK
, TXN_REASON_FK
, PRICE_TYPE_FK
, PRICE_BREAK_FK
, ACCPT_REQUIRED_FK
, FROZEN_FK
, APPROVED_FK
, USER_HOLD_FK
, CONFIRM_ORDER_FK
, SUPPLY_AGREE_FK
, NEG_BY_PREPARE_FK
, CANCELLED_FK
, LNE_CLOSED_FK
, EDI_PROCESSED_FK
, BASE_UOM_FK
, TXN_UOM_FK
, BILL_LOCATION_FK
, SHIP_LOCATION_FK
, SUP_SITE_GEOG_FK
, TXN_CUR_CODE_FK
, TXN_CUR_RATE_TYPE
, PO_LINE_TYPE_FK
, CONTRACT_EFFECTIVE_FK
, SUPPLIER_ITEM_NUM_FK
, AMT_AGREED_T
, AMT_AGREED_G
, QTY_ORDERED_T
, QTY_MIN_ORDER_T
, QTY_MAX_ORDER_T
, MARKET_PRICE_T
, MARKET_PRICE_G
, PRICE_LIMIT_T
, PRICE_LIMIT_G
, LIST_PRICE_T
, LIST_PRICE_G
, UNIT_PRICE_T
, UNIT_PRICE_G
, AMT_MIN_RELEASE_T
, AMT_MIN_RELEASE_G
, QTY_AGREED_T
, QTY_RELEASED_T
, AMT_RELEASED_T
, AMT_RELEASED_G
, NUM_DAYS_CREATE_TO_APP
, NUM_DAYS_APP_TO_SEND
, NUM_DAYS_APP_SEND_TO_ACCPT
, ITEM_ID
, ITEM_DESCRIPTION
, PO_SUPPLIER_NOTE
, COMMENTS
, RECEIVER_NOTE
, PO_HEADER_ID
, PO_LINE_ID
, CANCEL_REASON
, LAST_UPDATE_DATE
, DUNS_FK
, UNSPSC_FK
, SIC_CODE_FK
, COLLECTION_STATUS
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
, NULL USER_ATTRIBUTE6
, NULL USER_ATTRIBUTE7
, NULL USER_ATTRIBUTE8
, NULL USER_ATTRIBUTE9
, NULL USER_ATTRIBUTE10
, NULL USER_ATTRIBUTE11
, NULL USER_ATTRIBUTE12
, NULL USER_ATTRIBUTE13
, NULL USER_ATTRIBUTE14
, NULL USER_ATTRIBUTE15
, TO_NUMBER(NULL) USER_MEASURE1
, TO_NUMBER(NULL) USER_MEASURE2
, TO_NUMBER(NULL) USER_MEASURE3
, TO_NUMBER(NULL) USER_MEASURE4
, TO_NUMBER(NULL) USER_MEASURE5
, 'NA_EDW' USER_FK1
, 'NA_EDW' USER_FK2
, 'NA_EDW' USER_FK3
, 'NA_EDW' USER_FK4
, 'NA_EDW' USER_FK5
FROM POABV_EDW_AGREEMENT_LINES_FCV