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

VIEW: APPS.POA_EDW_AGREEMENT_LINES_FCV

Object Details
Object Name: POA_EDW_AGREEMENT_LINES_FCV
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POA_EDW_AGREEMENT_LINES_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
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
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
,      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;

Dependencies

[top of page]

APPS.POA_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
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
ViewPOABV_EDW_AGREEMENT_LINES_FCV
PL/SQL PackagePOA_EDW_SPEND_PKG - show dependent code
PL/SQL PackagePOA_OLTP_GENERIC_PKG - show dependent code
APPS.POA_EDW_AGREEMENT_LINES_FCV is referenced by following:

SchemaAPPS
Package BodyPOA_EDW_ALINES_F_C - show dependent code