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


VIEW: PO.PO_LINE_LOCATIONS_DRAFT_ALL#

Object Details
Object Name: PO_LINE_LOCATIONS_DRAFT_ALL#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_LOCATION_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
PO_HEADER_ID NUMBER
Yes
PO_LINE_ID NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

QUANTITY NUMBER

QUANTITY_ACCEPTED NUMBER

QUANTITY_RECEIVED NUMBER

QUANTITY_REJECTED NUMBER

QUANTITY_BILLED NUMBER

QUANTITY_CANCELLED NUMBER

UNIT_MEAS_LOOKUP_CODE VARCHAR2 (25)
PO_RELEASE_ID NUMBER

SHIP_TO_LOCATION_ID NUMBER

SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
NEED_BY_DATE DATE

PROMISED_DATE DATE

LAST_ACCEPT_DATE DATE

PRICE_OVERRIDE NUMBER

ENCUMBERED_FLAG VARCHAR2 (1)
ENCUMBERED_DATE DATE

UNENCUMBERED_QUANTITY NUMBER

FOB_LOOKUP_CODE VARCHAR2 (25)
FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)
TAXABLE_FLAG VARCHAR2 (1)
TAX_NAME VARCHAR2 (30)
ESTIMATED_TAX_AMOUNT NUMBER

FROM_HEADER_ID NUMBER

FROM_LINE_ID NUMBER

FROM_LINE_LOCATION_ID NUMBER

START_DATE DATE

END_DATE DATE

LEAD_TIME NUMBER

LEAD_TIME_UNIT VARCHAR2 (25)
PRICE_DISCOUNT NUMBER

TERMS_ID NUMBER

APPROVED_FLAG VARCHAR2 (1)
APPROVED_DATE DATE

CLOSED_FLAG VARCHAR2 (1)
CANCEL_FLAG VARCHAR2 (1)
CANCELLED_BY NUMBER (9)
CANCEL_DATE DATE

CANCEL_REASON VARCHAR2 (240)
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
FIRM_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
UNIT_OF_MEASURE_CLASS VARCHAR2 (25)
ENCUMBER_NOW VARCHAR2 (1)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
QTY_RCV_TOLERANCE NUMBER

QTY_RCV_EXCEPTION_CODE VARCHAR2 (25)
ENFORCE_SHIP_TO_LOCATION_CODE VARCHAR2 (25)
ALLOW_SUBSTITUTE_RECEIPTS_FLAG VARCHAR2 (1)
DAYS_EARLY_RECEIPT_ALLOWED NUMBER

DAYS_LATE_RECEIPT_ALLOWED NUMBER

RECEIPT_DAYS_EXCEPTION_CODE VARCHAR2 (25)
INVOICE_CLOSE_TOLERANCE NUMBER

RECEIVE_CLOSE_TOLERANCE NUMBER

SHIP_TO_ORGANIZATION_ID NUMBER

SHIPMENT_NUM NUMBER

SOURCE_SHIPMENT_ID NUMBER

SHIPMENT_TYPE VARCHAR2 (25) Yes
CLOSED_CODE VARCHAR2 (30)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

USSGL_TRANSACTION_CODE VARCHAR2 (30)
GOVERNMENT_CONTEXT VARCHAR2 (30)
RECEIVING_ROUTING_ID NUMBER

ACCRUE_ON_RECEIPT_FLAG VARCHAR2 (1)
CLOSED_REASON VARCHAR2 (240)
CLOSED_DATE DATE

CLOSED_BY NUMBER (9)
ORG_ID NUMBER

QUANTITY_SHIPPED 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)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
TAX_USER_OVERRIDE_FLAG VARCHAR2 (1)
MATCH_OPTION VARCHAR2 (25)
TAX_CODE_ID NUMBER

CALCULATE_TAX_FLAG VARCHAR2 (1)
CHANGE_PROMISED_DATE_REASON VARCHAR2 (240)
NOTE_TO_RECEIVER VARCHAR2 (480)
SECONDARY_QUANTITY NUMBER

SECONDARY_UNIT_OF_MEASURE VARCHAR2 (25)
PREFERRED_GRADE VARCHAR2 (150)
SECONDARY_QUANTITY_RECEIVED NUMBER

SECONDARY_QUANTITY_ACCEPTED NUMBER

SECONDARY_QUANTITY_REJECTED NUMBER

SECONDARY_QUANTITY_CANCELLED NUMBER

SECONDARY_QUANTITY_SHIPPED NUMBER

VMI_FLAG VARCHAR2 (1)
CONSIGNED_FLAG VARCHAR2 (1)
RETROACTIVE_DATE DATE

SUPPLIER_ORDER_LINE_NUMBER VARCHAR2 (25)
AMOUNT NUMBER

AMOUNT_RECEIVED NUMBER

AMOUNT_BILLED NUMBER

AMOUNT_CANCELLED NUMBER

AMOUNT_REJECTED NUMBER

AMOUNT_ACCEPTED NUMBER

DROP_SHIP_FLAG VARCHAR2 (1)
SALES_ORDER_UPDATE_DATE DATE

TRANSACTION_FLOW_HEADER_ID NUMBER

FINAL_MATCH_FLAG VARCHAR2 (1)
MANUAL_PRICE_CHANGE_FLAG VARCHAR2 (1)
SHIPMENT_CLOSED_DATE DATE

CLOSED_FOR_RECEIVING_DATE DATE

CLOSED_FOR_INVOICE_DATE DATE

CHANGE_ACCEPTED_FLAG VARCHAR2 (1)
DELETE_FLAG VARCHAR2 (1)
DRAFT_ID NUMBER
Yes
VALUE_BASIS VARCHAR2 (25)
MATCHING_BASIS VARCHAR2 (30)
PAYMENT_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
WORK_APPROVER_ID NUMBER

BID_PAYMENT_ID NUMBER

QUANTITY_FINANCED NUMBER

AMOUNT_FINANCED NUMBER

QUANTITY_RECOUPED NUMBER

AMOUNT_RECOUPED NUMBER

RETAINAGE_WITHHELD_AMOUNT NUMBER

RETAINAGE_RELEASED_AMOUNT NUMBER

AMOUNT_SHIPPED NUMBER

OUTSOURCED_ASSEMBLY NUMBER
Yes
TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
CONTROL_ACTION VARCHAR2 (30)
CHANGE_STATUS VARCHAR2 (30)
UDA_TEMPLATE_ID NUMBER

CLM_PERIOD_PERF_END_DATE DATE

CLM_PERIOD_PERF_START_DATE DATE

OLD_QUANTITY NUMBER

OLD_AMOUNT NUMBER

REVISION_NUM NUMBER

CLM_DELIVERY_PERIOD NUMBER

CLM_DELIVERY_PERIOD_UOM VARCHAR2 (25)
CLM_POP_DURATION NUMBER

CLM_POP_DURATION_UOM VARCHAR2 (25)
CLM_PROMISE_PERIOD NUMBER

CLM_PROMISE_PERIOD_UOM VARCHAR2 (25)
COMMENTS VARCHAR2 (2000)
Query Text

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


SELECT LINE_LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      PO_LINE_ID
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      QUANTITY
,      QUANTITY_ACCEPTED
,      QUANTITY_RECEIVED
,      QUANTITY_REJECTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      UNIT_MEAS_LOOKUP_CODE
,      PO_RELEASE_ID
,      SHIP_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      NEED_BY_DATE
,      PROMISED_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      ENCUMBERED_FLAG
,      ENCUMBERED_DATE
,      UNENCUMBERED_QUANTITY
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      TAXABLE_FLAG
,      TAX_NAME
,      ESTIMATED_TAX_AMOUNT
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      START_DATE
,      END_DATE
,      LEAD_TIME
,      LEAD_TIME_UNIT
,      PRICE_DISCOUNT
,      TERMS_ID
,      APPROVED_FLAG
,      APPROVED_DATE
,      CLOSED_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      UNIT_OF_MEASURE_CLASS
,      ENCUMBER_NOW
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      QTY_RCV_TOLERANCE
,      QTY_RCV_EXCEPTION_CODE
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      ALLOW_SUBSTITUTE_RECEIPTS_FLAG
,      DAYS_EARLY_RECEIPT_ALLOWED
,      DAYS_LATE_RECEIPT_ALLOWED
,      RECEIPT_DAYS_EXCEPTION_CODE
,      INVOICE_CLOSE_TOLERANCE
,      RECEIVE_CLOSE_TOLERANCE
,      SHIP_TO_ORGANIZATION_ID
,      SHIPMENT_NUM
,      SOURCE_SHIPMENT_ID
,      SHIPMENT_TYPE
,      CLOSED_CODE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      RECEIVING_ROUTING_ID
,      ACCRUE_ON_RECEIPT_FLAG
,      CLOSED_REASON
,      CLOSED_DATE
,      CLOSED_BY
,      ORG_ID
,      QUANTITY_SHIPPED
,      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
,      COUNTRY_OF_ORIGIN_CODE
,      TAX_USER_OVERRIDE_FLAG
,      MATCH_OPTION
,      TAX_CODE_ID
,      CALCULATE_TAX_FLAG
,      CHANGE_PROMISED_DATE_REASON
,      NOTE_TO_RECEIVER
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      SECONDARY_QUANTITY_RECEIVED
,      SECONDARY_QUANTITY_ACCEPTED
,      SECONDARY_QUANTITY_REJECTED
,      SECONDARY_QUANTITY_CANCELLED
,      SECONDARY_QUANTITY_SHIPPED
,      VMI_FLAG
,      CONSIGNED_FLAG
,      RETROACTIVE_DATE
,      SUPPLIER_ORDER_LINE_NUMBER
,      AMOUNT
,      AMOUNT_RECEIVED
,      AMOUNT_BILLED
,      AMOUNT_CANCELLED
,      AMOUNT_REJECTED
,      AMOUNT_ACCEPTED
,      DROP_SHIP_FLAG
,      SALES_ORDER_UPDATE_DATE
,      TRANSACTION_FLOW_HEADER_ID
,      FINAL_MATCH_FLAG
,      MANUAL_PRICE_CHANGE_FLAG
,      SHIPMENT_CLOSED_DATE
,      CLOSED_FOR_RECEIVING_DATE
,      CLOSED_FOR_INVOICE_DATE
,      CHANGE_ACCEPTED_FLAG
,      DELETE_FLAG
,      DRAFT_ID
,      VALUE_BASIS
,      MATCHING_BASIS
,      PAYMENT_TYPE
,      DESCRIPTION
,      WORK_APPROVER_ID
,      BID_PAYMENT_ID
,      QUANTITY_FINANCED
,      AMOUNT_FINANCED
,      QUANTITY_RECOUPED
,      AMOUNT_RECOUPED
,      RETAINAGE_WITHHELD_AMOUNT
,      RETAINAGE_RELEASED_AMOUNT
,      AMOUNT_SHIPPED
,      OUTSOURCED_ASSEMBLY
,      TAX_ATTRIBUTE_UPDATE_CODE
,      CONTROL_ACTION
,      CHANGE_STATUS
,      UDA_TEMPLATE_ID
,      CLM_PERIOD_PERF_END_DATE
,      CLM_PERIOD_PERF_START_DATE
,      OLD_QUANTITY
,      OLD_AMOUNT
,      REVISION_NUM
,      CLM_DELIVERY_PERIOD
,      CLM_DELIVERY_PERIOD_UOM
,      CLM_POP_DURATION
,      CLM_POP_DURATION_UOM
,      CLM_PROMISE_PERIOD
,      CLM_PROMISE_PERIOD_UOM
,      COMMENTS
FROM PO.PO_LINE_LOCATIONS_DRAFT_ALL#;

Dependencies

[top of page]

PO.PO_LINE_LOCATIONS_DRAFT_ALL# references the following:

SchemaPO
TablePO_LINE_LOCATIONS_DRAFT_ALL
PO.PO_LINE_LOCATIONS_DRAFT_ALL# is referenced by following:

SchemaAPPS
SynonymPO_LINE_LOCATIONS_DRAFT_ALL