[Home] [Help] [Dependency Information]
Object Name: | POA_EDW_AGREEMENT_LINES_FCV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PO.POA_EDW_AGREEMENT_LINES_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 | Sequence number | ||
VIEW_ID | NUMBER | View ID | ||
AGREE_LN_INST_PK | VARCHAR2 | (71) | Agreement LIne Instance PK | |
INSTANCE_FK | VARCHAR2 | (30) | Source Database instance FK | |
BUYER_FK | VARCHAR2 | (4000) | Buyer FK | |
APPROVER_FK | VARCHAR2 | (4000) | Approver FK | |
ITEM_REVISION_FK | VARCHAR2 | (4000) | Item Revision FK | |
SUPPLIER_SITE_FK | VARCHAR2 | (4000) | Supplier Site FK | |
OPERATING_UNIT_FK | VARCHAR2 | (4000) | Operating Unit FK | |
PO_CREATE_DATE_FK | VARCHAR2 | (4000) | PO Creation Date FK | |
LNE_CREAT_DATE_FK | VARCHAR2 | (4000) | Contract Line Creation Date FK | |
APPROVED_DATE_FK | VARCHAR2 | (4000) | Approved Date FK | |
REVISED_DATE_FK | VARCHAR2 | (4000) | Revised Date FK | |
START_DATE_FK | VARCHAR2 | (4000) | Effectivity start date | |
END_DATE_FK | VARCHAR2 | (4000) | Effectivity end date | |
ACCPT_DUE_DATE_FK | VARCHAR2 | (4000) | Acceptance Due date FK | |
TXN_CUR_DATE_FK | VARCHAR2 | (4000) | Transactional currency rate date FK | |
PO_PRINT_DATE_FK | VARCHAR2 | (4000) | PO Print Date FK | |
AP_TERMS_FK | VARCHAR2 | (74) | AP Terms FK | |
PO_CLOSED_FK | VARCHAR2 | (43) | PO Closed FK | |
PO_TYPE_FK | VARCHAR2 | (44) | PO Type FK | |
SHIP_VIA_FK | VARCHAR2 | (43) | Ship Via FK | |
FOB_FK | VARCHAR2 | (32) | FOB FK | |
FREIGHT_TERMS_FK | VARCHAR2 | (42) | Freight Terms FK | |
TXN_REASON_FK | VARCHAR2 | (47) | Transaction reason FK | |
PRICE_TYPE_FK | VARCHAR2 | (39) | Price Type FK | |
PRICE_BREAK_FK | VARCHAR2 | (45) | Price Break FK | |
ACCPT_REQUIRED_FK | VARCHAR2 | (12) | Acceptance required FK | |
FROZEN_FK | VARCHAR2 | (12) | Frozen flag FK | |
APPROVED_FK | VARCHAR2 | (12) | Approved Flag FK | |
USER_HOLD_FK | VARCHAR2 | (12) | User Hold Flag FK | |
CONFIRM_ORDER_FK | VARCHAR2 | (12) | Confirm Order FK | |
SUPPLY_AGREE_FK | VARCHAR2 | (12) | Supply Agreement Flag FK | |
NEG_BY_PREPARE_FK | VARCHAR2 | (12) | Negotiated by Preparer FK | |
CANCELLED_FK | VARCHAR2 | (12) | Cancelled flag FK | |
LNE_CLOSED_FK | VARCHAR2 | (12) | Line CLosed FK | |
EDI_PROCESSED_FK | VARCHAR2 | (12) | EDI Processed FK | |
BASE_UOM_FK | VARCHAR2 | (4000) | Base UOM FK | |
TXN_UOM_FK | VARCHAR2 | (4000) | Transactional UOM FK | |
BILL_LOCATION_FK | VARCHAR2 | (243) | Billing Location FK | |
SHIP_LOCATION_FK | VARCHAR2 | (4000) | Ship-to Location FK | |
SUP_SITE_GEOG_FK | VARCHAR2 | (223) | Supplier Site Geography FK | |
TXN_CUR_CODE_FK | VARCHAR2 | (15) | Transactional Currency Code FK | |
TXN_CUR_RATE_TYPE | VARCHAR2 | (30) | Transactional Currency Rate TYpe | |
PO_LINE_TYPE_FK | VARCHAR2 | (25) | Yes | PO Line Type FK |
CONTRACT_EFFECTIVE_FK | VARCHAR2 | (12) | Contract Effective FK | |
SUPPLIER_ITEM_NUM_FK | VARCHAR2 | (4000) | Supplier Item Number FK | |
AMT_AGREED_T | NUMBER | Amount agreed (transactional) | ||
AMT_AGREED_G | NUMBER | Amount Agreed (warehouse) | ||
QTY_ORDERED_T | NUMBER | Quantity Ordered (transactional) | ||
QTY_MIN_ORDER_T | NUMBER | Min order Quantity (transactional) | ||
QTY_MAX_ORDER_T | NUMBER | Max order quantity (transactional) | ||
MARKET_PRICE_T | NUMBER | Market Price (transactional) | ||
MARKET_PRICE_G | NUMBER | market price (warehouse) | ||
PRICE_LIMIT_T | NUMBER | Price Limit (transactional) | ||
PRICE_LIMIT_G | NUMBER | Price Limit (warehouse currency) | ||
LIST_PRICE_T | NUMBER | List Price per unit (transactional currency) | ||
LIST_PRICE_G | NUMBER | List price per unit (warehouse) | ||
UNIT_PRICE_T | NUMBER | unit price (transactional) | ||
UNIT_PRICE_G | NUMBER | unit price (warehouse) | ||
AMT_MIN_RELEASE_T | NUMBER | Min release amount (transactional) | ||
AMT_MIN_RELEASE_G | NUMBER | Min release amount (warehouse) | ||
QTY_AGREED_T | NUMBER | Agreed quantity (transactional) | ||
QTY_RELEASED_T | NUMBER | Released Quantity (transactional) | ||
AMT_RELEASED_T | NUMBER | Release amount (transactional) | ||
AMT_RELEASED_G | NUMBER | Released amount (warehouse) | ||
NUM_DAYS_CREATE_TO_APP | NUMBER | Number of days from creation to approval | ||
NUM_DAYS_APP_TO_SEND | NUMBER | Number of days from approval to send | ||
NUM_DAYS_APP_SEND_TO_ACCPT | NUMBER | Number of days from send to acceptance | ||
ITEM_ID | NUMBER | Item ID | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
PO_SUPPLIER_NOTE | VARCHAR2 | (480) | PO Supplier Note | |
COMMENTS | VARCHAR2 | (240) | PO Comments | |
RECEIVER_NOTE | VARCHAR2 | (480) | Receiver Note | |
PO_HEADER_ID | NUMBER | Yes | PO Header ID | |
PO_LINE_ID | NUMBER | Yes | PO Line ID | |
CANCEL_REASON | VARCHAR2 | (240) | Cancellation Reason | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
DUNS_FK | VARCHAR2 | (0) | DUNS number FK | |
UNSPSC_FK | VARCHAR2 | (0) | UNSPSC number FK | |
SIC_CODE_FK | VARCHAR2 | (0) | SIC Code FK | |
COLLECTION_STATUS | VARCHAR2 | (18) | Collection status | |
USER_ATTRIBUTE1 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE2 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE3 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE4 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE5 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE6 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE7 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE8 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE9 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE10 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE11 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE12 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE13 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE14 | VARCHAR2 | (0) | User defined attribute | |
USER_ATTRIBUTE15 | VARCHAR2 | (0) | User defined attribute | |
USER_MEASURE1 | NUMBER | User defined measure | ||
USER_MEASURE2 | NUMBER | User defined measure | ||
USER_MEASURE3 | NUMBER | User defined measure | ||
USER_MEASURE4 | NUMBER | User defined measure | ||
USER_MEASURE5 | NUMBER | User defined measure | ||
USER_FK1 | CHAR | (6) | User defined FK | |
USER_FK2 | CHAR | (6) | User defined FK | |
USER_FK3 | CHAR | (6) | User defined FK | |
USER_FK4 | CHAR | (6) | User defined FK | |
USER_FK5 | CHAR | (6) | User defined FK |
Cut, paste (and edit) the following text to query this object:
SELECT SEQ_ID
, VIEW_ID
, AGREE_LN_INST_PK
, INSTANCE_FK
, BUYER_FK
, APPROVER_FK
, ITEM_REVISION_FK
, SUPPLIER_SITE_FK
, OPERATING_UNIT_FK
, PO_CREATE_DATE_FK
, LNE_CREAT_DATE_FK
, APPROVED_DATE_FK
, REVISED_DATE_FK
, START_DATE_FK
, END_DATE_FK
, ACCPT_DUE_DATE_FK
, TXN_CUR_DATE_FK
, PO_PRINT_DATE_FK
, AP_TERMS_FK
, PO_CLOSED_FK
, PO_TYPE_FK
, SHIP_VIA_FK
, FOB_FK
, FREIGHT_TERMS_FK
, TXN_REASON_FK
, PRICE_TYPE_FK
, PRICE_BREAK_FK
, ACCPT_REQUIRED_FK
, FROZEN_FK
, APPROVED_FK
, USER_HOLD_FK
, CONFIRM_ORDER_FK
, SUPPLY_AGREE_FK
, NEG_BY_PREPARE_FK
, CANCELLED_FK
, LNE_CLOSED_FK
, EDI_PROCESSED_FK
, BASE_UOM_FK
, TXN_UOM_FK
, BILL_LOCATION_FK
, SHIP_LOCATION_FK
, SUP_SITE_GEOG_FK
, TXN_CUR_CODE_FK
, TXN_CUR_RATE_TYPE
, PO_LINE_TYPE_FK
, CONTRACT_EFFECTIVE_FK
, SUPPLIER_ITEM_NUM_FK
, AMT_AGREED_T
, AMT_AGREED_G
, QTY_ORDERED_T
, QTY_MIN_ORDER_T
, QTY_MAX_ORDER_T
, MARKET_PRICE_T
, MARKET_PRICE_G
, PRICE_LIMIT_T
, PRICE_LIMIT_G
, LIST_PRICE_T
, LIST_PRICE_G
, UNIT_PRICE_T
, UNIT_PRICE_G
, AMT_MIN_RELEASE_T
, AMT_MIN_RELEASE_G
, QTY_AGREED_T
, QTY_RELEASED_T
, AMT_RELEASED_T
, AMT_RELEASED_G
, NUM_DAYS_CREATE_TO_APP
, NUM_DAYS_APP_TO_SEND
, NUM_DAYS_APP_SEND_TO_ACCPT
, ITEM_ID
, ITEM_DESCRIPTION
, PO_SUPPLIER_NOTE
, COMMENTS
, RECEIVER_NOTE
, PO_HEADER_ID
, PO_LINE_ID
, CANCEL_REASON
, LAST_UPDATE_DATE
, DUNS_FK
, UNSPSC_FK
, SIC_CODE_FK
, 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_AGREEMENT_LINES_FCV;
|
|
|