[Home] [Help] [Dependency Information]
Object Name: | PO_LINE_LOCATIONS_VAL_TYPE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
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 |
|
Name | Parameters | Result |
---|---|---|
PO_LINE_LOCATIONS_VAL_TYPE |
SELF(PO_LINE_LOCATIONS_VAL_TYPE) |
PO_LINE_LOCATIONS_VAL_TYPE |
|
|
|