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

VIEW: APPS.PO_LINE_LOCATIONS_AP_V

Object Details
Object Name: PO_LINE_LOCATIONS_AP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_LINE_LOCATIONS_AP_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)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
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

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
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)

ESTIMATED_TAX_AMOUNT NUMBER


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 Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LEAD_TIME NUMBER


LEAD_TIME_UNIT VARCHAR2 (25)

LINE_LOCATION_ID NUMBER
Yes
NEED_BY_DATE DATE


ORG_ID NUMBER

Organization identifier
PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
PO_RELEASE_ID NUMBER


PRICE_DISCOUNT NUMBER


PRICE_OVERRIDE NUMBER


PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
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


RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)

RECEIPT_REQUIRED_FLAG VARCHAR2 (1)

RECEIVE_CLOSE_TOLERANCE NUMBER


RECEIVING_ROUTING_ID NUMBER


REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
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


TAXABLE_FLAG VARCHAR2 (1)

TAX_NAME VARCHAR2 (0)

TERMS_ID NUMBER


UNENCUMBERED_QUANTITY NUMBER


UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)

UNIT_OF_MEASURE_CLASS VARCHAR2 (25)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

PO_NUMBER VARCHAR2 (20) Yes
LINE_NUM NUMBER
Yes
ITEM_ID NUMBER


ITEM_DESCRIPTION VARCHAR2 (240)

TYPE_1099 VARCHAR2 (10)

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 descriptive flex field segment
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
Global descriptive flex field segment
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
Global descriptive flex field segment
MATCH_OPTION VARCHAR2 (25)
TAX_CODE_ID NUMBER

Tax ID
ITEM_CATEGORY_ID NUMBER

PAY_ON_CODE VARCHAR2 (25)
HEADER_APPROVED_FLAG VARCHAR2 (1)
approved flag from po header level
CLOSED_CODE_DISP VARCHAR2 (80)
AMOUNT NUMBER

Amount on the shipments
AMOUNT_RECEIVED NUMBER

Amount received on the shipments
AMOUNT_BILLED NUMBER

Amount billed on the shipments
AMOUNT_CANCELLED NUMBER

Amount cancelled on shipments
MATCHING_BASIS VARCHAR2 (80)
Matching basis displayed value
MATCHING_BASIS_LOOKUP_CODE VARCHAR2 (30)
Matching basis lookup code
SHIPMENT_TYPE_DSP VARCHAR2 (80)
PAYMENT_TYPE VARCHAR2 (30)
Pay Item type
PAYMENT_TYPE_DSP VARCHAR2 (80)
QUANTITY_FINANCED NUMBER

For Financing Pay Items, the number of units which have been pre-paid
AMOUNT_FINANCED NUMBER

For Advances or Financing Pay Items, the amount which has been pre-paid
QUANTITY_RECOUPED NUMBER

For Financing Pay Items, the number of units for which prepayments have been liquidated
AMOUNT_RECOUPED NUMBER

For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated
RETAINAGE_WITHHELD_AMOUNT NUMBER

The total amount withheld as Retainage against this Pay Item
RETAINAGE_RELEASED_AMOUNT NUMBER

The amount of Retainage released for this Pay Item
QUANTITY_SHIPPED NUMBER

Quantity shipped
AMOUNT_SHIPPED NUMBER

Amount pending for Work Confirmation
DESCRIPTION VARCHAR2 (240)
Pay Item description
VENDOR_PRODUCT_NUM VARCHAR2 (25)
Supplier item number
TASK_ID NUMBER

Project accounting task unique identifier. (References PA_TASKS.task_id.)
VALUE_BASIS VARCHAR2 (25)
Value basis of the line location
ORDER_TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Value Basis of the parent PO Line for this Line Location
WORK_APPROVER_ID NUMBER

FND User ID of the Pay Item's Work Confirmation Owner
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
,      ESTIMATED_TAX_AMOUNT
,      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
,      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
,      TAXABLE_FLAG
,      TAX_NAME
,      TERMS_ID
,      UNENCUMBERED_QUANTITY
,      UNIT_MEAS_LOOKUP_CODE
,      UNIT_OF_MEASURE_CLASS
,      USSGL_TRANSACTION_CODE
,      PO_NUMBER
,      LINE_NUM
,      ITEM_ID
,      ITEM_DESCRIPTION
,      TYPE_1099
,      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
,      TAX_CODE_ID
,      ITEM_CATEGORY_ID
,      PAY_ON_CODE
,      HEADER_APPROVED_FLAG
,      CLOSED_CODE_DISP
,      AMOUNT
,      AMOUNT_RECEIVED
,      AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      MATCHING_BASIS
,      MATCHING_BASIS_LOOKUP_CODE
,      SHIPMENT_TYPE_DSP
,      PAYMENT_TYPE
,      PAYMENT_TYPE_DSP
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      QUANTITY_SHIPPED
,      AMOUNT_SHIPPED
,      DESCRIPTION
,      VENDOR_PRODUCT_NUM
,      TASK_ID
,      VALUE_BASIS
,      ORDER_TYPE_LOOKUP_CODE
,      WORK_APPROVER_ID
FROM APPS.PO_LINE_LOCATIONS_AP_V;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_AP_V references the following:

SchemaAPPS
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
PL/SQL PackagePO_LINE_LOCATIONS_AP_PKG - show dependent code
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ALL
APPS.PO_LINE_LOCATIONS_AP_V is referenced by following:

SchemaAPPS
Package BodyAP_ETAX_UTILITY_PKG - show dependent code
Package BodyAP_MATCHING_PKG - show dependent code
Package BodyAP_PO_AMT_MATCH_PKG - show dependent code
Package BodyAP_RCT_AMT_MATCH_PKG - show dependent code
Package BodyAP_RECT_MATCH_PKG - show dependent code
Package BodyAP_RECURRING_INVOICES_PKG - show dependent code