FND Design Data [Home] [Help]

View: POA_EDW_PO_DIST_F_IV

Product: POA - Purchasing Intelligence (Obsolete)
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
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