VIEW: APPS.POA_EDW_PO_DISTRIBUTIONS_FCV

Source

View Text - Preformatted

SELECT seq_id, view_id, po_dist_inst_pk, supplier_item_fk, instance_fk, purch_class_fk, buyer_fk, deliver_to_fk, approver_fk, item_fk, supplier_site_fk, ship_to_org_fk, destin_org_fk, sob_fk, ship_location_fk, bill_location_fk, deliv_location_fk, sup_site_geog_fk, task_fk, po_create_date_fk, lne_creat_date_fk, shp_creat_date_fk, dst_creat_date_fk, po_app_date_fk, revised_date_fk, accpt_due_date_fk, release_date_fk, shp_app_date_fk, lst_accpt_date_fk, need_by_date_fk, promised_date_fk, printed_date_fk, txn_cur_date_fk, req_creat_date_fk, req_apprv_date_fk, po_accept_date_fk, ap_terms_fk, shipment_type_fk, ship_via_fk, fob_fk, freight_terms_fk, txn_reason_fk, price_type_fk, price_break_fk, shp_closed_fk, destin_type_fk, contract_type_fk, rcv_routing_fk, accpt_required_fk, frozen_fk, release_hold_fk, confirm_order_fk, neg_by_prepare_fk, sub_receipt_fk, shp_approved_fk, shp_cancelled_fk, inspection_req_fk, receipt_req_fk, accrued_fk, dst_encumb_fk, online_req_fk, shp_taxable_fk, edi_processed_fk, pcard_process_fk, apprv_supplier_fk, edw_base_uom_fk, edw_uom_fk, txn_cur_code_fk, po_line_type_fk, check_cut_date_fk, inv_received_date_fk, inv_creation_date_fk, goods_received_date_fk, duns_fk, unspsc_fk, sic_code_fk, po_creation_cycle_time, order_to_pay_cycle_time, receive_to_pay_cycl_time, inv_creation_cycle_time, inv_to_pay_cycle_time, ipv_t, ipv_g, amt_purchased_t, amt_purchased_g, amt_contract_t, amt_contract_g, amt_noncontract_t, amt_noncontract_g, amt_leakage_t, amt_leakage_g, potential_svg_t, potential_svg_g, amt_billed_t, amt_billed_g, qty_billed_b, qty_cancelled_b, qty_delivered_b, qty_ordered_b, price_t, price_g, list_prc_unit_t, list_prc_unit_g, market_price_t, market_price_g, price_limit_t, price_limit_g, item_id, item_description, supplier_note, lne_supplier_note, po_comments, po_receiver_note, supplier_prod_num, shp_cancel_reason, shp_closed_reason, shp_src_ship_id, distribution_id, line_location_id, po_header_id, po_line_id, po_release_id, source_dist_id, revision_num, po_number, contract_num, release_num, ccid, last_update_date, decode(global_currency_rate, -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY', 'LOCAL READY') 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_po_distributions_fcv

View Text - HTML Formatted

SELECT SEQ_ID
, VIEW_ID
, PO_DIST_INST_PK
, SUPPLIER_ITEM_FK
, INSTANCE_FK
, PURCH_CLASS_FK
, BUYER_FK
, DELIVER_TO_FK
, APPROVER_FK
, ITEM_FK
, SUPPLIER_SITE_FK
, SHIP_TO_ORG_FK
, DESTIN_ORG_FK
, SOB_FK
, SHIP_LOCATION_FK
, BILL_LOCATION_FK
, DELIV_LOCATION_FK
, SUP_SITE_GEOG_FK
, TASK_FK
, PO_CREATE_DATE_FK
, LNE_CREAT_DATE_FK
, SHP_CREAT_DATE_FK
, DST_CREAT_DATE_FK
, PO_APP_DATE_FK
, REVISED_DATE_FK
, ACCPT_DUE_DATE_FK
, RELEASE_DATE_FK
, SHP_APP_DATE_FK
, LST_ACCPT_DATE_FK
, NEED_BY_DATE_FK
, PROMISED_DATE_FK
, PRINTED_DATE_FK
, TXN_CUR_DATE_FK
, REQ_CREAT_DATE_FK
, REQ_APPRV_DATE_FK
, PO_ACCEPT_DATE_FK
, AP_TERMS_FK
, SHIPMENT_TYPE_FK
, SHIP_VIA_FK
, FOB_FK
, FREIGHT_TERMS_FK
, TXN_REASON_FK
, PRICE_TYPE_FK
, PRICE_BREAK_FK
, SHP_CLOSED_FK
, DESTIN_TYPE_FK
, CONTRACT_TYPE_FK
, RCV_ROUTING_FK
, ACCPT_REQUIRED_FK
, FROZEN_FK
, RELEASE_HOLD_FK
, CONFIRM_ORDER_FK
, NEG_BY_PREPARE_FK
, SUB_RECEIPT_FK
, SHP_APPROVED_FK
, SHP_CANCELLED_FK
, INSPECTION_REQ_FK
, RECEIPT_REQ_FK
, ACCRUED_FK
, DST_ENCUMB_FK
, ONLINE_REQ_FK
, SHP_TAXABLE_FK
, EDI_PROCESSED_FK
, PCARD_PROCESS_FK
, APPRV_SUPPLIER_FK
, EDW_BASE_UOM_FK
, EDW_UOM_FK
, TXN_CUR_CODE_FK
, PO_LINE_TYPE_FK
, CHECK_CUT_DATE_FK
, INV_RECEIVED_DATE_FK
, INV_CREATION_DATE_FK
, GOODS_RECEIVED_DATE_FK
, DUNS_FK
, UNSPSC_FK
, SIC_CODE_FK
, PO_CREATION_CYCLE_TIME
, ORDER_TO_PAY_CYCLE_TIME
, RECEIVE_TO_PAY_CYCL_TIME
, INV_CREATION_CYCLE_TIME
, INV_TO_PAY_CYCLE_TIME
, IPV_T
, IPV_G
, AMT_PURCHASED_T
, AMT_PURCHASED_G
, AMT_CONTRACT_T
, AMT_CONTRACT_G
, AMT_NONCONTRACT_T
, AMT_NONCONTRACT_G
, AMT_LEAKAGE_T
, AMT_LEAKAGE_G
, POTENTIAL_SVG_T
, POTENTIAL_SVG_G
, AMT_BILLED_T
, AMT_BILLED_G
, QTY_BILLED_B
, QTY_CANCELLED_B
, QTY_DELIVERED_B
, QTY_ORDERED_B
, PRICE_T
, PRICE_G
, LIST_PRC_UNIT_T
, LIST_PRC_UNIT_G
, MARKET_PRICE_T
, MARKET_PRICE_G
, PRICE_LIMIT_T
, PRICE_LIMIT_G
, ITEM_ID
, ITEM_DESCRIPTION
, SUPPLIER_NOTE
, LNE_SUPPLIER_NOTE
, PO_COMMENTS
, PO_RECEIVER_NOTE
, SUPPLIER_PROD_NUM
, SHP_CANCEL_REASON
, SHP_CLOSED_REASON
, SHP_SRC_SHIP_ID
, DISTRIBUTION_ID
, LINE_LOCATION_ID
, PO_HEADER_ID
, PO_LINE_ID
, PO_RELEASE_ID
, SOURCE_DIST_ID
, REVISION_NUM
, PO_NUMBER
, CONTRACT_NUM
, RELEASE_NUM
, CCID
, LAST_UPDATE_DATE
, DECODE(GLOBAL_CURRENCY_RATE
, -1
, 'RATE NOT AVAILABLE'
, -2
, 'INVALID CURRENCY'
, 'LOCAL READY') 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_PO_DISTRIBUTIONS_FCV