[Home] [Help] [Dependency Information]
Object Name: | JAI_OM_LC_MATCHING_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JA.JAI_OM_LC_MATCHING_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SLNO | NUMBER | A Running Serial number for the Letter for Credit. | ||
CUSTOMER_ID | NUMBER | Customer Identifier against whom the Order is billed. | ||
ORDER_HEADER_ID | NUMBER | The header identifier of the order against which this LC is matched. | ||
ORDER_LINE_ID | NUMBER | The Line identifier of the order against which this LC is matched. | ||
QTY_RELEASED | NUMBER | Quantity that has been released which can be matched against this LC and shipped. | ||
QTY_MATCHED | NUMBER | The Quantity that has been actually matched. | ||
LC_TYPE | VARCHAR2 | (25) | The Type of the LC . Values include Revolving etc. | |
LC_NUMBER | NUMBER | Yes | LC Number . This is based in a sequence. | |
AMOUNT | NUMBER | The LC Amount. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
CREATED_BY | VARCHAR2 | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT SLNO
, CUSTOMER_ID
, ORDER_HEADER_ID
, ORDER_LINE_ID
, QTY_RELEASED
, QTY_MATCHED
, LC_TYPE
, LC_NUMBER
, AMOUNT
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
FROM APPS.JAI_OM_LC_MATCHING_V;
APPS.JAI_OM_LC_MATCHING_V is not referenced by any database object
|
|
|