[Home] [Help] [Dependency Information]
Object Name: | JAI_CMN_MATCH_RECEIPTS# |
---|---|
Object Type: | VIEW |
Owner: | JA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECEIPT_ID | NUMBER | Yes | ||
REF_LINE_ID | NUMBER | Yes | ||
SUBINVENTORY | VARCHAR2 | (20) | ||
QUANTITY_APPLIED | NUMBER | Yes | ||
ISSUE_UOM | VARCHAR2 | (3) | ||
ORDER_INVOICE | VARCHAR2 | (2) | Yes | |
SHIP_STATUS | VARCHAR2 | (8) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
RECEIPT_QUANTITY_APPLIED | NUMBER | |||
RECEIPT_QUANTITY_UOM | VARCHAR2 | (4) | ||
REF_LINE_NO | NUMBER | (4) | ||
OBJECT_VERSION_NUMBER | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RECEIPT_ID
, REF_LINE_ID
, SUBINVENTORY
, QUANTITY_APPLIED
, ISSUE_UOM
, ORDER_INVOICE
, SHIP_STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, RECEIPT_QUANTITY_APPLIED
, RECEIPT_QUANTITY_UOM
, REF_LINE_NO
, OBJECT_VERSION_NUMBER
FROM JA.JAI_CMN_MATCH_RECEIPTS#;
|
|
|