DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.POABV_EDW_AGREEMENT_LINES_FCV

Object Details
Object Name: POABV_EDW_AGREEMENT_LINES_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POABV_EDW_AGREEMENT_LINES_FCV
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


EDW Contract Agreement LIne Fact Collection View


[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQ_ID NUMBER

Sequence Id
VIEW_ID NUMBER

View Id
AGREE_LN_INST_PK VARCHAR2 (71)
Agreement Line INstance PK
INSTANCE_FK VARCHAR2 (30)
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)
PO 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)
Start Date FK
END_DATE_FK VARCHAR2 (4000)
End date FK
ACCPT_DUE_DATE_FK VARCHAR2 (4000)
Acceptance Due Date FK
TXN_CUR_DATE_FK VARCHAR2 (4000)
Transaction Currency 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 FK
APPROVED_FK VARCHAR2 (12)
Approved FK
USER_HOLD_FK VARCHAR2 (12)
User Hold FK
CONFIRM_ORDER_FK VARCHAR2 (12)
Confirm Order FK
SUPPLY_AGREE_FK VARCHAR2 (12)
Supply Agree FK
NEG_BY_PREPARE_FK VARCHAR2 (12)
Neg By Prepare FK
CANCELLED_FK VARCHAR2 (12)
Cancelled FK
LNE_CLOSED_FK VARCHAR2 (12)
Line Closed FK
EDI_PROCESSED_FK VARCHAR2 (12)
EDI Processed FK
BASE_UOM_FK VARCHAR2 (4000)
Base Unit of Measure FK
TXN_UOM_FK VARCHAR2 (4000)
Transaction 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)
Transaction Currency Code FK
TXN_CUR_RATE_TYPE VARCHAR2 (30)
Transaction 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

Amounted Agreed (Global currency)
QTY_ORDERED_T NUMBER

Quantity Ordered (transactional)
QTY_MIN_ORDER_T NUMBER

Quantity mininum order (transactional)
QTY_MAX_ORDER_T NUMBER

Quantity Maximum order (transactional)
MARKET_PRICE_T NUMBER

Market Prcie (transactional)
MARKET_PRICE_G NUMBER

Market Price (global currency)
PRICE_LIMIT_T NUMBER

price limit (transactinoal currency)
PRICE_LIMIT_G NUMBER

Price limit (global currency)
LIST_PRICE_T NUMBER

List Price (transactional currency)
LIST_PRICE_G NUMBER

List Price (global currency)
UNIT_PRICE_T NUMBER

Unit Pirce (transactional currency)
UNIT_PRICE_G NUMBER

Unit Price (global currency)
AMT_MIN_RELEASE_T NUMBER

mininum Amount to release (transactional)
AMT_MIN_RELEASE_G NUMBER

min amount to release (global)
QTY_AGREED_T NUMBER

Quantity agreed (transactional)
QTY_RELEASED_T NUMBER

Quantity released (transactional)
AMT_RELEASED_T NUMBER

amount released (transactional)
AMT_RELEASED_G NUMBER

Amount released (global currency)
NUM_DAYS_CREATE_TO_APP NUMBER

Days from creation to approval
NUM_DAYS_APP_TO_SEND NUMBER

Days from approval to send
NUM_DAYS_APP_SEND_TO_ACCPT NUMBER

Days from send to acceptance
ITEM_ID NUMBER

Item Id
ITEM_DESCRIPTION VARCHAR2 (240)
Item Description
PO_SUPPLIER_NOTE VARCHAR2 (480)
Supplier Note
COMMENTS VARCHAR2 (240)
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)
Cancel 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
_DF:PO_HDR:_EDW CHAR (21)
flexfield
_DF:PO_LINES:_EDW CHAR (19)
flexfield
Query Text

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
,      _DF:PO_HDR:_EDW
,      _DF:PO_LINES:_EDW
FROM APPS.POABV_EDW_AGREEMENT_LINES_FCV;

Dependencies

[top of page]

APPS.POABV_EDW_AGREEMENT_LINES_FCV references the following:

SchemaAPPS
PL/SQL PackageEDW_CURRENCY - show dependent code
PL/SQL PackageEDW_GEOGRAPHY_PKG - show dependent code
PL/SQL PackageEDW_HR_PERSON_PKG - show dependent code
PL/SQL PackageEDW_ITEMS_PKG - show dependent code
SynonymEDW_LOCAL_INSTANCE
PL/SQL PackageEDW_ORGANIZATION_PKG - show dependent code
PL/SQL PackageEDW_SUPPLIER_ITEM_PKG - show dependent code
PL/SQL PackageEDW_TIME_PKG - show dependent code
PL/SQL PackageEDW_TRD_PARTNER_PKG - show dependent code
PL/SQL PackageEDW_UTIL - show dependent code
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewGL_SETS_OF_BOOKS
SynonymHR_LOCATIONS_ALL
SynonymMTL_UNITS_OF_MEASURE
SynonymPOA_EDW_ALINES_INC
PL/SQL PackagePOA_EDW_SPEND_PKG - show dependent code
PL/SQL PackagePOA_OLTP_GENERIC_PKG - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_TYPES
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.POABV_EDW_AGREEMENT_LINES_FCV is referenced by following:

SchemaAPPS
ViewPOA_EDW_AGREEMENT_LINES_FCV