VIEW: APPS.POA_EDW_RECEIVING_TXN_FCV

Source

View Text - Preformatted

SELECT /*+ ALL_ROWS */ seq_id, view_id, RCV_TXN_PK, INSTANCE_FK, TXN_TYPE_FK, ITEM_REVISION_FK, PO_LINE_TYPE_FK, EDW_BASE_UOM_FK, EDW_UOM_FK, RECEIPT_SOURCE_FK, SUPPLIER_SITE_FK, sup_site_geog_fk, DESTIN_TYPE_FK, RCV_DEL_TO_ORG_FK, RCV_LOCATION_FK, DELIV_LOCATION_FK, LOCATOR_FK, BUYER_FK, DELIVER_TO_FK, TXN_DATE_FK, TXN_CREAT_FK, SHIPPED_TO_DATE_FK, EXPCT_RCV_DATE_FK, PROMISED_DATE_FK, NEED_BY_DATE_FK, LST_ACCPT_DATE_FK, SRC_CREAT_DATE_FK, PARNT_TXN_DATE_FK, AP_TERMS_FK, RCV_ROUTING_FK, SUBST_UNORD_FK, PARNT_TXN_TYPE_FK, FREIGHT_TERMS_FK, INSPECT_STATUS_FK, INSPECT_QUAL_FK, RECEIVE_EXCEP_FK, USER_ENTERED_FK, TXN_REASON_FK, TXN_CUR_CODE_FK, Purchase_Class_Code_FK, supplier_item_num_fk, /*** Measures ***/ QTY_TXN, QTY_TXN_NET, QTY_RECEIVED, QTY_ACCEPT, QTY_REJECT, QTY_RETURN_TO_VENDOR, QTY_RETURN_TO_RECEIVING, QTY_DELIVER, QTY_TRANSFER, PRICE_T, PRICE_G, NUM_DAYS_TO_FULL_DEL, /*** Attributes ***/ SHIPMENT_NUM, INVOICE_NUM, RECEIPT_NUM_INST, SOURCE_TXN_NUMBER, VENDOR_LOT_NUM, RMA_REFERENCE, TXN_COMMENTS, SHIP_HDR_COMMENTS, WAY_AIRBILL_NUM, BILL_OF_LADING , PACKING_SLIP, /*** Others ***/ last_update_date, creation_date, DUNS_FK, UNSPSC_FK, SIC_CODE_FK, po_distribution_id, 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_RECEIVING_TXN_FCV

View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ SEQ_ID
, VIEW_ID
, RCV_TXN_PK
, INSTANCE_FK
, TXN_TYPE_FK
, ITEM_REVISION_FK
, PO_LINE_TYPE_FK
, EDW_BASE_UOM_FK
, EDW_UOM_FK
, RECEIPT_SOURCE_FK
, SUPPLIER_SITE_FK
, SUP_SITE_GEOG_FK
, DESTIN_TYPE_FK
, RCV_DEL_TO_ORG_FK
, RCV_LOCATION_FK
, DELIV_LOCATION_FK
, LOCATOR_FK
, BUYER_FK
, DELIVER_TO_FK
, TXN_DATE_FK
, TXN_CREAT_FK
, SHIPPED_TO_DATE_FK
, EXPCT_RCV_DATE_FK
, PROMISED_DATE_FK
, NEED_BY_DATE_FK
, LST_ACCPT_DATE_FK
, SRC_CREAT_DATE_FK
, PARNT_TXN_DATE_FK
, AP_TERMS_FK
, RCV_ROUTING_FK
, SUBST_UNORD_FK
, PARNT_TXN_TYPE_FK
, FREIGHT_TERMS_FK
, INSPECT_STATUS_FK
, INSPECT_QUAL_FK
, RECEIVE_EXCEP_FK
, USER_ENTERED_FK
, TXN_REASON_FK
, TXN_CUR_CODE_FK
, PURCHASE_CLASS_CODE_FK
, SUPPLIER_ITEM_NUM_FK
, /*** MEASURES ***/ QTY_TXN
, QTY_TXN_NET
, QTY_RECEIVED
, QTY_ACCEPT
, QTY_REJECT
, QTY_RETURN_TO_VENDOR
, QTY_RETURN_TO_RECEIVING
, QTY_DELIVER
, QTY_TRANSFER
, PRICE_T
, PRICE_G
, NUM_DAYS_TO_FULL_DEL
, /*** ATTRIBUTES ***/ SHIPMENT_NUM
, INVOICE_NUM
, RECEIPT_NUM_INST
, SOURCE_TXN_NUMBER
, VENDOR_LOT_NUM
, RMA_REFERENCE
, TXN_COMMENTS
, SHIP_HDR_COMMENTS
, WAY_AIRBILL_NUM
, BILL_OF_LADING
, PACKING_SLIP
, /*** OTHERS ***/ LAST_UPDATE_DATE
, CREATION_DATE
, DUNS_FK
, UNSPSC_FK
, SIC_CODE_FK
, PO_DISTRIBUTION_ID
, 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_RECEIVING_TXN_FCV