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


VIEW: APPS.AP_PO_CORRECTIONS_V

Object Details
Object Name: AP_PO_CORRECTIONS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewSQLAP.AP_PO_CORRECTIONS_V
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
ROW_ID ROWID (10)
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
APPROVED_DATE DATE

APPROVED_FLAG VARCHAR2 (1)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
CANCELLED_BY NUMBER (9)
CANCEL_DATE DATE

CANCEL_FLAG VARCHAR2 (1)
CANCEL_REASON VARCHAR2 (240)
CLOSED_BY NUMBER (9)
CLOSED_CODE VARCHAR2 (30)
CLOSED_DATE DATE

CLOSED_FLAG VARCHAR2 (1)
CLOSED_REASON VARCHAR2 (240)
CREATED_BY NUMBER

CREATION_DATE DATE

DAYS_EARLY_RECEIPT_ALLOWED NUMBER

DAYS_LATE_RECEIPT_ALLOWED NUMBER

ENCUMBERED_DATE DATE

ENCUMBERED_FLAG VARCHAR2 (1)
ENCUMBER_NOW VARCHAR2 (1)
END_DATE DATE

ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
FIRM_DATE DATE

FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
FOB_LOOKUP_CODE VARCHAR2 (25)
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
FROM_HEADER_ID NUMBER

FROM_LINE_ID NUMBER

FROM_LINE_LOCATION_ID NUMBER

GOVERNMENT_CONTEXT VARCHAR2 (30)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
INVOICE_CLOSE_TOLERANCE NUMBER

LAST_ACCEPT_DATE DATE

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LEAD_TIME NUMBER

LEAD_TIME_UNIT VARCHAR2 (25)
LINE_LOCATION_ID NUMBER
Yes
NEED_BY_DATE DATE

ORG_ID NUMBER

PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
PO_RELEASE_ID NUMBER

PRICE_DISCOUNT NUMBER

PRICE_OVERRIDE NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROMISED_DATE DATE

QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
QTY_RCV_TOLERANCE NUMBER

QUANTITY NUMBER

QUANTITY_ACCEPTED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

QUANTITY_RECEIVED NUMBER

QUANTITY_REJECTED NUMBER

AMOUNT NUMBER

AMOUNT_BILLED NUMBER

AMOUNT_CANCELLED NUMBER

AMOUNT_RECEIVED NUMBER

RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
RECEIVE_CLOSE_TOLERANCE NUMBER

RECEIVING_ROUTING_ID NUMBER

REQUEST_ID NUMBER

SHIPMENT_NUM NUMBER

SHIPMENT_TYPE VARCHAR2 (25) Yes
SHIP_TO_LOCATION_ID NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
SOURCE_SHIPMENT_ID NUMBER

START_DATE DATE

TERMS_ID NUMBER

UNENCUMBERED_QUANTITY NUMBER

UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
UNIT_OF_MEASURE_CLASS VARCHAR2 (25)
PO_NUMBER VARCHAR2 (20) Yes
LINE_NUM NUMBER
Yes
ITEM_ID NUMBER

ITEM_DESCRIPTION VARCHAR2 (240)
TYPE_1099 VARCHAR2 (10)
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes
RELEASE_NUM NUMBER

FREIGHT_TERMS VARCHAR2 (80)
PAYMENT_TERMS VARCHAR2 (50)
BUYER VARCHAR2 (240)
SHIP_TO_LOCATION VARCHAR2 (60)
LAST_RECEIPT_DATE DATE

REQUESTORS VARCHAR2 (4000)
NUM_DISTRIBUTIONS NUMBER

PO_APPROVED_FLAG VARCHAR2 (1)
CURRENCY_CODE VARCHAR2 (15)
VENDOR_ID NUMBER

GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
MATCH_OPTION VARCHAR2 (25)
ITEM_CATEGORY_ID NUMBER

PAY_ON_CODE VARCHAR2 (25)
HEADER_APPROVED_FLAG VARCHAR2 (1)
CLOSED_CODE_DISP VARCHAR2 (80)
INVOICE_NUMBER VARCHAR2 (50) Yes
INVOICE_ID NUMBER (15) Yes
INVOICE_AMOUNT NUMBER

INVOICE_DATE DATE

LINE_NUMBER NUMBER
Yes
LINE_QUANTITY_INVOICED NUMBER

LINE_UNIT_PRICE NUMBER

LINE_AMOUNT NUMBER
Yes
MATCHING_BASIS_LOOKUP_CODE VARCHAR2 (30) Yes
MATCHING_BASIS VARCHAR2 (80) Yes
AMOUNT_SHIPPED NUMBER

QUANTITY_SHIPPED NUMBER

PAYMENT_TYPE VARCHAR2 (30)
SHIPMENT_TYPE_DSP VARCHAR2 (80)
PAYMENT_TYPE_DSP VARCHAR2 (80)
DESCRIPTION VARCHAR2 (240)
VENDOR_PRODUCT_NUM VARCHAR2 (25)
TASK_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ACCRUE_ON_RECEIPT_FLAG
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      APPROVED_DATE
,      APPROVED_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE_CATEGORY
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_FLAG
,      CANCEL_REASON
,      CLOSED_BY
,      CLOSED_CODE
,      CLOSED_DATE
,      CLOSED_FLAG
,      CLOSED_REASON
,      CREATED_BY
,      CREATION_DATE
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      ENCUMBERED_DATE
,      ENCUMBERED_FLAG
,      ENCUMBER_NOW
,      END_DATE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      FIRM_DATE
,      FIRM_STATUS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      GOVERNMENT_CONTEXT
,      INSPECTION_REQUIRED_FLAG
,      INVOICE_CLOSE_TOLERANCE
,      LAST_ACCEPT_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      LINE_LOCATION_ID
,      NEED_BY_DATE
,      ORG_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      PO_RELEASE_ID
,      PRICE_DISCOUNT
,      PRICE_OVERRIDE
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROMISED_DATE
,      QTY_RCV_EXCEPTION_CODE
,      QTY_RCV_TOLERANCE
,      QUANTITY
,      QUANTITY_ACCEPTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      QUANTITY_RECEIVED
,      QUANTITY_REJECTED
,      AMOUNT
,      AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      AMOUNT_RECEIVED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      RECEIPT_REQUIRED_FLAG
,      RECEIVE_CLOSE_TOLERANCE
,      RECEIVING_ROUTING_ID
,      REQUEST_ID
,      SHIPMENT_NUM
,      SHIPMENT_TYPE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      SOURCE_SHIPMENT_ID
,      START_DATE
,      TERMS_ID
,      UNENCUMBERED_QUANTITY
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_OF_MEASURE_CLASS
,      PO_NUMBER
,      LINE_NUM
,      ITEM_ID
,      ITEM_DESCRIPTION
,      TYPE_1099
,      ORDER_TYPE_LOOKUP_CODE
,      RELEASE_NUM
,      FREIGHT_TERMS
,      PAYMENT_TERMS
,      BUYER
,      SHIP_TO_LOCATION
,      LAST_RECEIPT_DATE
,      REQUESTORS
,      NUM_DISTRIBUTIONS
,      PO_APPROVED_FLAG
,      CURRENCY_CODE
,      VENDOR_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      MATCH_OPTION
,      ITEM_CATEGORY_ID
,      PAY_ON_CODE
,      HEADER_APPROVED_FLAG
,      CLOSED_CODE_DISP
,      INVOICE_NUMBER
,      INVOICE_ID
,      INVOICE_AMOUNT
,      INVOICE_DATE
,      LINE_NUMBER
,      LINE_QUANTITY_INVOICED
,      LINE_UNIT_PRICE
,      LINE_AMOUNT
,      MATCHING_BASIS_LOOKUP_CODE
,      MATCHING_BASIS
,      AMOUNT_SHIPPED
,      QUANTITY_SHIPPED
,      PAYMENT_TYPE
,      SHIPMENT_TYPE_DSP
,      PAYMENT_TYPE_DSP
,      DESCRIPTION
,      VENDOR_PRODUCT_NUM
,      TASK_ID
FROM APPS.AP_PO_CORRECTIONS_V;

Dependencies

[top of page]

APPS.AP_PO_CORRECTIONS_V references the following:

SchemaAPPS
SynonymAP_INVOICES_ALL
SynonymAP_INVOICE_LINES_ALL
ViewAP_LOOKUP_CODES
SynonymAP_TERMS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL_TL
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
PL/SQL PackagePO_LINE_LOCATIONS_AP_PKG - show dependent code
SynonymPO_LINE_TYPES
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL

APPS.AP_PO_CORRECTIONS_V is not referenced by any database object