Skip to content

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

VIEW: OZF.OZF_SD_BATCH_LINES_ALL#

Object Details
Object Name: OZF_SD_BATCH_LINES_ALL#
Object Type: VIEW
Owner: OZF
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_LINE_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
BATCH_ID NUMBER
Yes
BATCH_LINE_NUMBER NUMBER
Yes
UTILIZATION_ID NUMBER
Yes
AGREEMENT_NUMBER VARCHAR2 (30)
SHIP_TO_ORG_ID NUMBER

SHIP_TO_CONTACT_ID NUMBER

SOLD_TO_SITE_USE_ID NUMBER

SOLD_TO_CONTACT_ID NUMBER

END_CUSTOMER_CONTACT_ID NUMBER

QUOTE_ID NUMBER

QUOTE_LINE_NUMBER NUMBER

ORDER_HEADER_ID NUMBER

ORDER_LINE_ID NUMBER

INVOICE_NUMBER NUMBER (15)
INVOICE_LINE_NUMBER NUMBER

RESALE_PRICE_CURRENCY_CODE VARCHAR2 (15)
RESALES_PRICE NUMBER

LIST_PRICE_CURRENCY_CODE VARCHAR2 (15)
LIST_PRICE NUMBER

AGREEMENT_CURRENCY_CODE VARCHAR2 (15)
AGREEMENT_PRICE NUMBER

STATUS_CODE VARCHAR2 (30)
APPROVED_AMOUNT NUMBER

APPROVED_CURRENCY_CODE VARCHAR2 (15)
CLAIM_AMOUNT NUMBER

BATCH_CURR_CLAIM_AMOUNT NUMBER

ITEM_ID NUMBER

SHIPPED_QUANTITY_UOM VARCHAR2 (3)
QUANTITY_SHIPPED NUMBER

PURGE_FLAG VARCHAR2 (1)
ORDER_DATE DATE
Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
REQUEST_ID NUMBER

CREATED_BY NUMBER (15) Yes
CREATED_FROM VARCHAR2 (30)
LAST_UPDATE_LOGIN NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER

PROGRAM_UPDATE_DATE DATE

PROGRAM_ID NUMBER

ORG_ID NUMBER

SECURITY_GROUP_ID NUMBER

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)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
CLAIM_AMOUNT_CURRENCY_CODE VARCHAR2 (15)
LAST_SUB_CLAIM_AMOUNT NUMBER

ACCTD_AMOUNT_REMAINING NUMBER

UNIV_CURR_AMOUNT_REMAINING NUMBER

AMOUNT_REMAINING NUMBER

VENDOR_ITEM_ID VARCHAR2 (240)
END_CUSTOMER_ID NUMBER

SOLD_TO_CUSTOMER_ID NUMBER

VENDOR_REF_ID VARCHAR2 (255)
TRANSMIT_FLAG VARCHAR2 (1)
PROCESS_FEED_FLAG VARCHAR2 (1)
FUND_REQUEST_AMOUNT_REMAINING NUMBER

DISCOUNT_TYPE VARCHAR2 (30)
DISCOUNT_VALUE NUMBER

DISCOUNT_CURRENCY_CODE VARCHAR2 (15)
COMPLETE_FLAG VARCHAR2 (1)
ORIGINAL_CLAIM_AMOUNT NUMBER (22)
BATCH_CURR_ORIG_CLAIM_AMOUNT NUMBER (22)
ADJ_UTILIZATION_ID NUMBER (22)
QUANTITY_APPROVED NUMBER (22)
ADJUSTMENT_TYPE_ID NUMBER (22)
ATTRIBUTE16 VARCHAR2 (150)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
ORDER_SOURCE VARCHAR2 (30)
TOTAL_APPROVED_AMT NUMBER

TOTAL_APPROVED_QTY NUMBER

PARENT_LINE_ID NUMBER

Query Text

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


SELECT BATCH_LINE_ID
,      OBJECT_VERSION_NUMBER
,      BATCH_ID
,      BATCH_LINE_NUMBER
,      UTILIZATION_ID
,      AGREEMENT_NUMBER
,      SHIP_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      SOLD_TO_SITE_USE_ID
,      SOLD_TO_CONTACT_ID
,      END_CUSTOMER_CONTACT_ID
,      QUOTE_ID
,      QUOTE_LINE_NUMBER
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      INVOICE_NUMBER
,      INVOICE_LINE_NUMBER
,      RESALE_PRICE_CURRENCY_CODE
,      RESALES_PRICE
,      LIST_PRICE_CURRENCY_CODE
,      LIST_PRICE
,      AGREEMENT_CURRENCY_CODE
,      AGREEMENT_PRICE
,      STATUS_CODE
,      APPROVED_AMOUNT
,      APPROVED_CURRENCY_CODE
,      CLAIM_AMOUNT
,      BATCH_CURR_CLAIM_AMOUNT
,      ITEM_ID
,      SHIPPED_QUANTITY_UOM
,      QUANTITY_SHIPPED
,      PURGE_FLAG
,      ORDER_DATE
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      CREATED_BY
,      CREATED_FROM
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      ORG_ID
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CLAIM_AMOUNT_CURRENCY_CODE
,      LAST_SUB_CLAIM_AMOUNT
,      ACCTD_AMOUNT_REMAINING
,      UNIV_CURR_AMOUNT_REMAINING
,      AMOUNT_REMAINING
,      VENDOR_ITEM_ID
,      END_CUSTOMER_ID
,      SOLD_TO_CUSTOMER_ID
,      VENDOR_REF_ID
,      TRANSMIT_FLAG
,      PROCESS_FEED_FLAG
,      FUND_REQUEST_AMOUNT_REMAINING
,      DISCOUNT_TYPE
,      DISCOUNT_VALUE
,      DISCOUNT_CURRENCY_CODE
,      COMPLETE_FLAG
,      ORIGINAL_CLAIM_AMOUNT
,      BATCH_CURR_ORIG_CLAIM_AMOUNT
,      ADJ_UTILIZATION_ID
,      QUANTITY_APPROVED
,      ADJUSTMENT_TYPE_ID
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      ORDER_SOURCE
,      TOTAL_APPROVED_AMT
,      TOTAL_APPROVED_QTY
,      PARENT_LINE_ID
FROM OZF.OZF_SD_BATCH_LINES_ALL#;

Dependencies

[top of page]

OZF.OZF_SD_BATCH_LINES_ALL# references the following:

SchemaOZF
TableOZF_SD_BATCH_LINES_ALL
OZF.OZF_SD_BATCH_LINES_ALL# is referenced by following:

SchemaAPPS
SynonymOZF_SD_BATCH_LINES_ALL