eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TYPE: APPS.PO_LINE_LOCATIONS_VAL_TYPE

Object Details

Object Name:	PO_LINE_LOCATIONS_VAL_TYPE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
LINE_LOCATION_ID	PO_TBL_NUMBER
LAST_UPDATE_DATE	PO_TBL_DATE
LAST_UPDATED_BY	PO_TBL_NUMBER
PO_HEADER_ID	PO_TBL_NUMBER
PO_LINE_ID	PO_TBL_NUMBER
LAST_UPDATE_LOGIN	PO_TBL_NUMBER
CREATION_DATE	PO_TBL_DATE
CREATED_BY	PO_TBL_NUMBER
QUANTITY	PO_TBL_NUMBER
QUANTITY_ACCEPTED	PO_TBL_NUMBER
QUANTITY_RECEIVED	PO_TBL_NUMBER
QUANTITY_REJECTED	PO_TBL_NUMBER
QUANTITY_BILLED	PO_TBL_NUMBER
QUANTITY_CANCELLED	PO_TBL_NUMBER
UNIT_MEAS_LOOKUP_CODE	PO_TBL_VARCHAR30
PO_RELEASE_ID	PO_TBL_NUMBER
SHIP_TO_LOCATION_ID	PO_TBL_NUMBER
SHIP_VIA_LOOKUP_CODE	PO_TBL_VARCHAR30
NEED_BY_DATE	PO_TBL_DATE
PROMISED_DATE	PO_TBL_DATE
LAST_ACCEPT_DATE	PO_TBL_DATE
PRICE_OVERRIDE	PO_TBL_NUMBER
ENCUMBERED_FLAG	PO_TBL_VARCHAR1
ENCUMBERED_DATE	PO_TBL_DATE
UNENCUMBERED_QUANTITY	PO_TBL_NUMBER
FOB_LOOKUP_CODE	PO_TBL_VARCHAR30
FREIGHT_TERMS_LOOKUP_CODE	PO_TBL_VARCHAR30
TAXABLE_FLAG	PO_TBL_VARCHAR1
TAX_NAME	PO_TBL_VARCHAR30
ESTIMATED_TAX_AMOUNT	PO_TBL_NUMBER
FROM_HEADER_ID	PO_TBL_NUMBER
FROM_LINE_ID	PO_TBL_NUMBER
FROM_LINE_LOCATION_ID	PO_TBL_NUMBER
START_DATE	PO_TBL_DATE
END_DATE	PO_TBL_DATE
LEAD_TIME	PO_TBL_NUMBER
LEAD_TIME_UNIT	PO_TBL_VARCHAR30
PRICE_DISCOUNT	PO_TBL_NUMBER
TERMS_ID	PO_TBL_NUMBER
APPROVED_FLAG	PO_TBL_VARCHAR1
APPROVED_DATE	PO_TBL_DATE
CLOSED_FLAG	PO_TBL_VARCHAR1
CANCEL_FLAG	PO_TBL_VARCHAR1
CANCELLED_BY	PO_TBL_NUMBER
CANCEL_DATE	PO_TBL_DATE
CANCEL_REASON	PO_TBL_VARCHAR2000
FIRM_STATUS_LOOKUP_CODE	PO_TBL_VARCHAR30
FIRM_DATE	PO_TBL_DATE
ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR30
ATTRIBUTE1	PO_TBL_VARCHAR2000
ATTRIBUTE2	PO_TBL_VARCHAR2000
ATTRIBUTE3	PO_TBL_VARCHAR2000
ATTRIBUTE4	PO_TBL_VARCHAR2000
ATTRIBUTE5	PO_TBL_VARCHAR2000
ATTRIBUTE6	PO_TBL_VARCHAR2000
ATTRIBUTE7	PO_TBL_VARCHAR2000
ATTRIBUTE8	PO_TBL_VARCHAR2000
ATTRIBUTE9	PO_TBL_VARCHAR2000
ATTRIBUTE10	PO_TBL_VARCHAR2000
UNIT_OF_MEASURE_CLASS	PO_TBL_VARCHAR30
ENCUMBER_NOW	PO_TBL_VARCHAR1
ATTRIBUTE11	PO_TBL_VARCHAR2000
ATTRIBUTE12	PO_TBL_VARCHAR2000
ATTRIBUTE13	PO_TBL_VARCHAR2000
ATTRIBUTE14	PO_TBL_VARCHAR2000
ATTRIBUTE15	PO_TBL_VARCHAR2000
INSPECTION_REQUIRED_FLAG	PO_TBL_VARCHAR1
RECEIPT_REQUIRED_FLAG	PO_TBL_VARCHAR1
QTY_RCV_TOLERANCE	PO_TBL_NUMBER
QTY_RCV_EXCEPTION_CODE	PO_TBL_VARCHAR30
ENFORCE_SHIP_TO_LOCATION_CODE	PO_TBL_VARCHAR30
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	PO_TBL_VARCHAR1
DAYS_EARLY_RECEIPT_ALLOWED	PO_TBL_NUMBER
DAYS_LATE_RECEIPT_ALLOWED	PO_TBL_NUMBER
RECEIPT_DAYS_EXCEPTION_CODE	PO_TBL_VARCHAR30
INVOICE_CLOSE_TOLERANCE	PO_TBL_NUMBER
RECEIVE_CLOSE_TOLERANCE	PO_TBL_NUMBER
SHIP_TO_ORGANIZATION_ID	PO_TBL_NUMBER
SHIPMENT_NUM	PO_TBL_NUMBER
SOURCE_SHIPMENT_ID	PO_TBL_NUMBER
SHIPMENT_TYPE	PO_TBL_VARCHAR30
CLOSED_CODE	PO_TBL_VARCHAR30
REQUEST_ID	PO_TBL_NUMBER
PROGRAM_APPLICATION_ID	PO_TBL_NUMBER
PROGRAM_ID	PO_TBL_NUMBER
PROGRAM_UPDATE_DATE	PO_TBL_DATE
USSGL_TRANSACTION_CODE	PO_TBL_VARCHAR30
GOVERNMENT_CONTEXT	PO_TBL_VARCHAR30
RECEIVING_ROUTING_ID	PO_TBL_NUMBER
ACCRUE_ON_RECEIPT_FLAG	PO_TBL_VARCHAR1
CLOSED_REASON	PO_TBL_VARCHAR2000
CLOSED_DATE	PO_TBL_DATE
CLOSED_BY	PO_TBL_NUMBER
ORG_ID	PO_TBL_NUMBER
QUANTITY_SHIPPED	PO_TBL_NUMBER
GLOBAL_ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE1	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE2	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE3	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE4	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE5	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE6	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE7	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE8	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE9	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE10	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE11	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE12	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE13	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE14	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE15	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE16	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE17	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE18	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE19	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE20	PO_TBL_VARCHAR2000
COUNTRY_OF_ORIGIN_CODE	PO_TBL_VARCHAR5
TAX_USER_OVERRIDE_FLAG	PO_TBL_VARCHAR1
MATCH_OPTION	PO_TBL_VARCHAR30
TAX_CODE_ID	PO_TBL_NUMBER
CALCULATE_TAX_FLAG	PO_TBL_VARCHAR1
CHANGE_PROMISED_DATE_REASON	PO_TBL_VARCHAR2000
NOTE_TO_RECEIVER	PO_TBL_VARCHAR2000
SECONDARY_QUANTITY	PO_TBL_NUMBER
SECONDARY_UNIT_OF_MEASURE	PO_TBL_VARCHAR30
PREFERRED_GRADE	PO_TBL_VARCHAR2000
SECONDARY_QUANTITY_RECEIVED	PO_TBL_NUMBER
SECONDARY_QUANTITY_ACCEPTED	PO_TBL_NUMBER
SECONDARY_QUANTITY_REJECTED	PO_TBL_NUMBER
SECONDARY_QUANTITY_CANCELLED	PO_TBL_NUMBER
SECONDARY_QUANTITY_SHIPPED	PO_TBL_NUMBER
VMI_FLAG	PO_TBL_VARCHAR1
CONSIGNED_FLAG	PO_TBL_VARCHAR1
RETROACTIVE_DATE	PO_TBL_DATE
SUPPLIER_ORDER_LINE_NUMBER	PO_TBL_VARCHAR30
AMOUNT	PO_TBL_NUMBER
AMOUNT_RECEIVED	PO_TBL_NUMBER
AMOUNT_BILLED	PO_TBL_NUMBER
AMOUNT_CANCELLED	PO_TBL_NUMBER
AMOUNT_REJECTED	PO_TBL_NUMBER
AMOUNT_ACCEPTED	PO_TBL_NUMBER
DROP_SHIP_FLAG	PO_TBL_VARCHAR1
SALES_ORDER_UPDATE_DATE	PO_TBL_DATE
TRANSACTION_FLOW_HEADER_ID	PO_TBL_NUMBER
FINAL_MATCH_FLAG	PO_TBL_VARCHAR1
MANUAL_PRICE_CHANGE_FLAG	PO_TBL_VARCHAR1
SHIPMENT_CLOSED_DATE	PO_TBL_DATE
CLOSED_FOR_RECEIVING_DATE	PO_TBL_DATE
CLOSED_FOR_INVOICE_DATE	PO_TBL_DATE
CHANGE_ACCEPTED_FLAG	PO_TBL_VARCHAR1
DELETE_FLAG	PO_TBL_VARCHAR1
DRAFT_ID	PO_TBL_NUMBER
VALUE_BASIS	PO_TBL_VARCHAR30
MATCHING_BASIS	PO_TBL_VARCHAR30
PAYMENT_TYPE	PO_TBL_VARCHAR30
DESCRIPTION	PO_TBL_VARCHAR2000
WORK_APPROVER_ID	PO_TBL_NUMBER
BID_PAYMENT_ID	PO_TBL_NUMBER
QUANTITY_FINANCED	PO_TBL_NUMBER
AMOUNT_FINANCED	PO_TBL_NUMBER
QUANTITY_RECOUPED	PO_TBL_NUMBER
AMOUNT_RECOUPED	PO_TBL_NUMBER
RETAINAGE_WITHHELD_AMOUNT	PO_TBL_NUMBER
RETAINAGE_RELEASED_AMOUNT	PO_TBL_NUMBER
LINE_EXPIRATION_DATE	PO_TBL_DATE
LINE_ITEM_ID	PO_TBL_NUMBER
LINE_ORDER_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
LINE_COST_CONSTRAINT	PO_TBL_VARCHAR30
HDR_START_DATE	PO_TBL_DATE
HDR_END_DATE	PO_TBL_DATE
HDR_STYLE_ID	PO_TBL_NUMBER
INTERFACE_ID	PO_TBL_NUMBER
PURCHASE_BASIS	PO_TBL_VARCHAR30
ORDER_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
ITEM_ID	PO_TBL_NUMBER
FROM_DATE	PO_TBL_DATE
TO_DATE	PO_TBL_DATE
ITEM_REVISION	PO_TBL_VARCHAR5
FREIGHT_CARRIER	PO_TBL_VARCHAR30
FIRM_FLAG	PO_TBL_VARCHAR30
ITEM	PO_TBL_VARCHAR2000
LINE_PRICE_BREAK_LOOKUP_CODE	PO_TBL_VARCHAR30
LINE_UNIT_PRICE	PO_TBL_NUMBER
LINE_QUANTITY	PO_TBL_NUMBER
LINE_AMOUNT	PO_TBL_NUMBER
CONTROL_ACTION	PO_TBL_VARCHAR30
CLM_PERIOD_PERF_START_DATE	PO_TBL_DATE
CLM_PERIOD_PERF_END_DATE	PO_TBL_DATE
PAR_DRAFT_ID	PO_TBL_VARCHAR4000

Methods

Name	Parameters	Result
PO_LINE_LOCATIONS_VAL_TYPE	SELF(PO_LINE_LOCATIONS_VAL_TYPE)	PO_LINE_LOCATIONS_VAL_TYPE

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_VAL_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR30; PO_TBL_VARCHAR4000; PO_TBL_VARCHAR5

APPS.PO_LINE_LOCATIONS_VAL_TYPE is referenced by following:

APPS: PO_LINE_LOCATIONS_VAL_TYPE; PO_MOD_SYNC_PROCESS_PVT - show dependent code; PO_PDOI_LINE_LOC_PROCESS_PVT - show dependent code; PO_VALIDATIONS - show dependent code; PO_VALIDATIONS - show dependent code