[Home] [Help] [Dependency Information]
Object Name: | JAI_RETRO_LINE_CHANGES# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_CHANGE_ID | NUMBER | (22) | Yes | |
DOC_TYPE | VARCHAR2 | (30) | Yes | |
DOC_HEADER_ID | NUMBER | (22) | Yes | |
DOC_LINE_ID | NUMBER | (22) | Yes | |
LINE_LOCATION_ID | NUMBER | (22) | ||
FROM_HEADER_ID | NUMBER | (22) | ||
FROM_LINE_ID | NUMBER | (22) | ||
DOC_VERSION_NUMBER | NUMBER | (15) | Yes | |
SOURCE_LINE_CHANGE_ID | NUMBER | (22) | ||
PRICE_CHANGE_DATE | DATE | Yes | ||
INVENTORY_ITEM_ID | NUMBER | (22) | ||
ORGANIZATION_ID | NUMBER | (22) | ||
ORIGINAL_UNIT_PRICE | NUMBER | Yes | ||
MODIFIED_UNIT_PRICE | NUMBER | Yes | ||
RECEIPT_PROCESSED_FLAG | VARCHAR2 | (1) | Yes | |
EXCISE_ACTION | VARCHAR2 | (15) | ||
VAT_ACTION | VARCHAR2 | (25) | ||
EXCISE_INVOICE_NO | VARCHAR2 | (30) | ||
EXCISE_INVOICE_DATE | DATE | |||
VAT_INVOICE_NO | VARCHAR2 | (30) | ||
VAT_INVOICE_DATE | DATE | |||
RETRO_REQUEST_ID | NUMBER | (22) | ||
DOC_NUMBER | VARCHAR2 | (30) | ||
VENDOR_ID | NUMBER | (22) | ||
VENDOR_SITE_ID | NUMBER | (22) | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (22) | ||
LAST_UPDATED_BY | NUMBER | (22) | Yes | |
CREATED_BY | NUMBER | (22) | Yes | |
OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_CHANGE_ID
, DOC_TYPE
, DOC_HEADER_ID
, DOC_LINE_ID
, LINE_LOCATION_ID
, FROM_HEADER_ID
, FROM_LINE_ID
, DOC_VERSION_NUMBER
, SOURCE_LINE_CHANGE_ID
, PRICE_CHANGE_DATE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, ORIGINAL_UNIT_PRICE
, MODIFIED_UNIT_PRICE
, RECEIPT_PROCESSED_FLAG
, EXCISE_ACTION
, VAT_ACTION
, EXCISE_INVOICE_NO
, EXCISE_INVOICE_DATE
, VAT_INVOICE_NO
, VAT_INVOICE_DATE
, RETRO_REQUEST_ID
, DOC_NUMBER
, VENDOR_ID
, VENDOR_SITE_ID
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATED_BY
, OBJECT_VERSION_NUMBER
FROM JA.JAI_RETRO_LINE_CHANGES#;
|
|
|