[Home] [Help] [Dependency Information]

VIEW: APPS.POA_EDW_PO_DISTRIBUTIONS_FCV

Object Details

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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;

Dependencies

[top of page]

APPS

EDW_GEOGRAPHY_PKG - show dependent code

EDW_ITEMS_PKG - show dependent code

EDW_UTIL - show dependent code

POABV_EDW_PO_DISTRIBUTIONS_FCV

POA_EDW_VARIABLES_PKG - show dependent code

POA_OLTP_GENERIC_PKG - show dependent code

APPS

POA_EDW_PO_DIST_F_C - show dependent code