Product: | POA - Purchasing Intelligence (Obsolete) |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT ROWID ROW_ID
, ACCPT_DUE_DATE_FK_KEY
, ACCPT_REQUIRED_FK_KEY
, ACCRUED_FK_KEY
, AMT_BILLED_G
, AMT_BILLED_T
, AMT_CONTRACT_G
, AMT_CONTRACT_T
, AMT_LEAKAGE_G
, AMT_LEAKAGE_T
, AMT_NONCONTRACT_G
, AMT_NONCONTRACT_T
, AMT_PURCHASED_G
, AMT_PURCHASED_T
, APPROVER_FK_KEY
, AP_TERMS_FK_KEY
, BILL_LOCATION_FK_KEY
, BUYER_FK_KEY
, CONFIRM_ORDER_FK_KEY
, CONTRACT_NUM
, CONTRACT_TYPE_FK_KEY
, CREATION_DATE
, DELIVER_TO_FK_KEY
, DELIV_LOCATION_FK_KEY
, DESTIN_ORG_FK_KEY
, DESTIN_TYPE_FK_KEY
, DISTRIBUTION_ID
, DST_CREAT_DATE_FK_KEY
, DST_ENCUMB_FK_KEY
, EDI_PROCESSED_FK_KEY
, FOB_FK_KEY
, FREIGHT_TERMS_FK_KEY
, FROZEN_FK_KEY
, INSPECTION_REQ_FK_KEY
, INSTANCE_FK_KEY
, ITEM_DESCRIPTION
, ITEM_ID
, ITEM_FK_KEY
, LAST_UPDATE_DATE
, LINE_LOCATION_ID
, LIST_PRC_UNIT_G
, LIST_PRC_UNIT_T
, LNE_CREAT_DATE_FK_KEY
, LNE_SUPPLIER_NOTE
, LST_ACCPT_DATE_FK_KEY
, MARKET_PRICE_G
, MARKET_PRICE_T
, NEED_BY_DATE_FK_KEY
, NEG_BY_PREPARE_FK_KEY
, ONLINE_REQ_FK_KEY
, PCARD_PROCESS_FK_KEY
, POTENTIAL_SVG_G
, POTENTIAL_SVG_T
, PO_ACCEPT_DATE_FK_KEY
, PO_APP_DATE_FK_KEY
, PO_COMMENTS
, PO_CREATE_DATE_FK_KEY
, PO_DIST_INST_PK
, PO_DIST_INST_PK_KEY
, PO_HEADER_ID
, PO_LINE_ID
, PO_LINE_TYPE_FK_KEY
, PO_NUMBER
, PO_RECEIVER_NOTE
, PO_RELEASE_ID
, PRICE_BREAK_FK_KEY
, PRICE_G
, PRICE_LIMIT_G
, PRICE_LIMIT_T
, PRICE_T
, PRICE_TYPE_FK_KEY
, PRINTED_DATE_FK_KEY
, PROMISED_DATE_FK_KEY
, PURCH_CLASS_FK_KEY
, QTY_BILLED_B
, QTY_CANCELLED_B
, QTY_DELIVERED_B
, QTY_ORDERED_B
, RCV_ROUTING_FK_KEY
, RECEIPT_REQ_FK_KEY
, RELEASE_DATE_FK_KEY
, RELEASE_HOLD_FK_KEY
, RELEASE_NUM
, REQ_APPRV_DATE_FK_KEY
, REQ_CREAT_DATE_FK_KEY
, REVISED_DATE_FK_KEY
, REVISION_NUM
, SHIPMENT_TYPE_FK_KEY
, SHIP_LOCATION_FK_KEY
, SHIP_TO_ORG_FK_KEY
, SHIP_VIA_FK_KEY
, SHP_APPROVED_FK_KEY
, SHP_APP_DATE_FK_KEY
, SHP_CANCELLED_FK_KEY
, SHP_CANCEL_REASON
, SHP_CLOSED_FK_KEY
, SHP_CLOSED_REASON
, SHP_CREAT_DATE_FK_KEY
, SHP_SRC_SHIP_ID
, SHP_TAXABLE_FK_KEY
, SOB_FK_KEY
, SOURCE_DIST_ID
, SUB_RECEIPT_FK_KEY
, SUPPLIER_ITEM_FK_KEY
, SUPPLIER_NOTE
, SUPPLIER_SITE_FK_KEY
, SUP_SITE_GEOG_FK_KEY
, TXN_CUR_CODE_FK_KEY
, TXN_CUR_DATE_FK_KEY
, TXN_REASON_FK_KEY
, EDW_UOM_FK_KEY
, EDW_BASE_UOM_FK_KEY
, USER_ATTRIBUTE1
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_FK1_KEY
, USER_FK2_KEY
, USER_FK3_KEY
, USER_FK4_KEY
, USER_FK5_KEY
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, ' ' OPERATION_CODE
FROM POA_EDW_PO_DIST_F