[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_PO_DISTRIBUTIONS_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_EDW_PO_DISTRIBUTIONS_FCV |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQ_ID | NUMBER | |||
VIEW_ID | NUMBER | |||
PO_DIST_INST_PK | VARCHAR2 | (71) | ||
SUPPLIER_ITEM_FK | VARCHAR2 | (282) | ||
INSTANCE_FK | VARCHAR2 | (30) | ||
PURCH_CLASS_FK | CHAR | (6) | ||
BUYER_FK | VARCHAR2 | (85) | ||
DELIVER_TO_FK | VARCHAR2 | (85) | ||
APPROVER_FK | VARCHAR2 | (85) | ||
ITEM_FK | VARCHAR2 | (4000) | ||
SUPPLIER_SITE_FK | VARCHAR2 | (126) | ||
SHIP_TO_ORG_FK | VARCHAR2 | (71) | ||
DESTIN_ORG_FK | VARCHAR2 | (71) | ||
SOB_FK | VARCHAR2 | (71) | ||
SHIP_LOCATION_FK | VARCHAR2 | (4000) | ||
BILL_LOCATION_FK | VARCHAR2 | (243) | ||
DELIV_LOCATION_FK | VARCHAR2 | (4000) | ||
SUP_SITE_GEOG_FK | VARCHAR2 | (223) | ||
TASK_FK | VARCHAR2 | (78) | ||
PO_CREATE_DATE_FK | VARCHAR2 | (76) | ||
LNE_CREAT_DATE_FK | VARCHAR2 | (76) | ||
SHP_CREAT_DATE_FK | VARCHAR2 | (76) | ||
DST_CREAT_DATE_FK | VARCHAR2 | (76) | ||
PO_APP_DATE_FK | VARCHAR2 | (76) | ||
REVISED_DATE_FK | VARCHAR2 | (76) | ||
ACCPT_DUE_DATE_FK | VARCHAR2 | (76) | ||
RELEASE_DATE_FK | VARCHAR2 | (76) | ||
SHP_APP_DATE_FK | VARCHAR2 | (76) | ||
LST_ACCPT_DATE_FK | VARCHAR2 | (76) | ||
NEED_BY_DATE_FK | VARCHAR2 | (76) | ||
PROMISED_DATE_FK | VARCHAR2 | (76) | ||
PRINTED_DATE_FK | VARCHAR2 | (76) | ||
TXN_CUR_DATE_FK | VARCHAR2 | (76) | ||
REQ_CREAT_DATE_FK | VARCHAR2 | (76) | ||
REQ_APPRV_DATE_FK | VARCHAR2 | (76) | ||
PO_ACCEPT_DATE_FK | VARCHAR2 | (76) | ||
AP_TERMS_FK | VARCHAR2 | (74) | ||
SHIPMENT_TYPE_FK | VARCHAR2 | (42) | ||
SHIP_VIA_FK | VARCHAR2 | (43) | ||
FOB_FK | VARCHAR2 | (32) | ||
FREIGHT_TERMS_FK | VARCHAR2 | (42) | ||
TXN_REASON_FK | VARCHAR2 | (47) | ||
PRICE_TYPE_FK | VARCHAR2 | (39) | ||
PRICE_BREAK_FK | VARCHAR2 | (45) | ||
SHP_CLOSED_FK | VARCHAR2 | (48) | ||
DESTIN_TYPE_FK | VARCHAR2 | (45) | ||
CONTRACT_TYPE_FK | VARCHAR2 | (27) | ||
RCV_ROUTING_FK | VARCHAR2 | (96) | ||
ACCPT_REQUIRED_FK | VARCHAR2 | (12) | ||
FROZEN_FK | VARCHAR2 | (12) | ||
RELEASE_HOLD_FK | VARCHAR2 | (12) | ||
CONFIRM_ORDER_FK | VARCHAR2 | (12) | ||
NEG_BY_PREPARE_FK | VARCHAR2 | (12) | ||
SUB_RECEIPT_FK | VARCHAR2 | (12) | ||
SHP_APPROVED_FK | VARCHAR2 | (12) | ||
SHP_CANCELLED_FK | VARCHAR2 | (12) | ||
INSPECTION_REQ_FK | VARCHAR2 | (12) | ||
RECEIPT_REQ_FK | VARCHAR2 | (12) | ||
ACCRUED_FK | VARCHAR2 | (12) | ||
DST_ENCUMB_FK | VARCHAR2 | (12) | ||
ONLINE_REQ_FK | VARCHAR2 | (12) | ||
SHP_TAXABLE_FK | VARCHAR2 | (12) | ||
EDI_PROCESSED_FK | VARCHAR2 | (12) | ||
PCARD_PROCESS_FK | VARCHAR2 | (12) | ||
APPRV_SUPPLIER_FK | VARCHAR2 | (4000) | ||
EDW_BASE_UOM_FK | VARCHAR2 | (4000) | ||
EDW_UOM_FK | VARCHAR2 | (4000) | ||
TXN_CUR_CODE_FK | VARCHAR2 | (15) | ||
PO_LINE_TYPE_FK | VARCHAR2 | (25) | Yes | |
CHECK_CUT_DATE_FK | VARCHAR2 | (76) | ||
INV_RECEIVED_DATE_FK | VARCHAR2 | (76) | ||
INV_CREATION_DATE_FK | VARCHAR2 | (76) | ||
GOODS_RECEIVED_DATE_FK | VARCHAR2 | (76) | ||
DUNS_FK | VARCHAR2 | (0) | ||
UNSPSC_FK | VARCHAR2 | (0) | ||
SIC_CODE_FK | VARCHAR2 | (0) | ||
PO_CREATION_CYCLE_TIME | NUMBER | |||
ORDER_TO_PAY_CYCLE_TIME | VARCHAR2 | (40) | ||
RECEIVE_TO_PAY_CYCL_TIME | NUMBER | |||
INV_CREATION_CYCLE_TIME | VARCHAR2 | (40) | ||
INV_TO_PAY_CYCLE_TIME | VARCHAR2 | (40) | ||
IPV_T | VARCHAR2 | (40) | ||
IPV_G | VARCHAR2 | (40) | ||
AMT_PURCHASED_T | VARCHAR2 | (40) | ||
AMT_PURCHASED_G | VARCHAR2 | (40) | ||
AMT_CONTRACT_T | VARCHAR2 | (40) | ||
AMT_CONTRACT_G | VARCHAR2 | (40) | ||
AMT_NONCONTRACT_T | VARCHAR2 | (40) | ||
AMT_NONCONTRACT_G | VARCHAR2 | (40) | ||
AMT_LEAKAGE_T | VARCHAR2 | (40) | ||
AMT_LEAKAGE_G | VARCHAR2 | (40) | ||
POTENTIAL_SVG_T | VARCHAR2 | (40) | ||
POTENTIAL_SVG_G | VARCHAR2 | (40) | ||
AMT_BILLED_T | VARCHAR2 | (40) | ||
AMT_BILLED_G | VARCHAR2 | (40) | ||
QTY_BILLED_B | VARCHAR2 | (40) | ||
QTY_CANCELLED_B | NUMBER | |||
QTY_DELIVERED_B | NUMBER | |||
QTY_ORDERED_B | VARCHAR2 | (40) | ||
PRICE_T | VARCHAR2 | (40) | ||
PRICE_G | VARCHAR2 | (40) | ||
LIST_PRC_UNIT_T | VARCHAR2 | (40) | ||
LIST_PRC_UNIT_G | VARCHAR2 | (40) | ||
MARKET_PRICE_T | VARCHAR2 | (40) | ||
MARKET_PRICE_G | VARCHAR2 | (40) | ||
PRICE_LIMIT_T | VARCHAR2 | (40) | ||
PRICE_LIMIT_G | VARCHAR2 | (40) | ||
ITEM_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
SUPPLIER_NOTE | VARCHAR2 | (480) | ||
LNE_SUPPLIER_NOTE | VARCHAR2 | (480) | ||
PO_COMMENTS | VARCHAR2 | (240) | ||
PO_RECEIVER_NOTE | VARCHAR2 | (480) | ||
SUPPLIER_PROD_NUM | VARCHAR2 | (25) | ||
SHP_CANCEL_REASON | VARCHAR2 | (240) | ||
SHP_CLOSED_REASON | VARCHAR2 | (240) | ||
SHP_SRC_SHIP_ID | NUMBER | |||
DISTRIBUTION_ID | NUMBER | Yes | ||
LINE_LOCATION_ID | NUMBER | |||
PO_HEADER_ID | NUMBER | Yes | ||
PO_LINE_ID | NUMBER | |||
PO_RELEASE_ID | NUMBER | |||
SOURCE_DIST_ID | NUMBER | |||
REVISION_NUM | NUMBER | |||
PO_NUMBER | VARCHAR2 | (20) | Yes | |
CONTRACT_NUM | VARCHAR2 | (20) | ||
RELEASE_NUM | NUMBER | |||
CCID | NUMBER | |||
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
COLLECTION_STATUS | VARCHAR2 | (18) | ||
USER_ATTRIBUTE1 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE2 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE3 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE4 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE5 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE6 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE7 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE8 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE9 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE10 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE11 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE12 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE13 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE14 | VARCHAR2 | (0) | ||
USER_ATTRIBUTE15 | VARCHAR2 | (0) | ||
USER_MEASURE1 | NUMBER | |||
USER_MEASURE2 | NUMBER | |||
USER_MEASURE3 | NUMBER | |||
USER_MEASURE4 | NUMBER | |||
USER_MEASURE5 | NUMBER | |||
USER_FK1 | CHAR | (6) | ||
USER_FK2 | CHAR | (6) | ||
USER_FK3 | CHAR | (6) | ||
USER_FK4 | CHAR | (6) | ||
USER_FK5 | CHAR | (6) |
Cut, paste (and edit) the following text to query this object:
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
, COLLECTION_STATUS
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, USER_ATTRIBUTE6
, USER_ATTRIBUTE7
, USER_ATTRIBUTE8
, USER_ATTRIBUTE9
, USER_ATTRIBUTE10
, USER_ATTRIBUTE11
, USER_ATTRIBUTE12
, USER_ATTRIBUTE13
, USER_ATTRIBUTE14
, USER_ATTRIBUTE15
, USER_MEASURE1
, USER_MEASURE2
, USER_MEASURE3
, USER_MEASURE4
, USER_MEASURE5
, USER_FK1
, USER_FK2
, USER_FK3
, USER_FK4
, USER_FK5
FROM APPS.POA_EDW_PO_DISTRIBUTIONS_FCV;
|
|
|