[Home] [Help] [Dependency Information]
Object Name: | INVBV_INTERORG_SHIPPING_INFO |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | INV.INVBV_INTERORG_SHIPPING_INFO |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This shows the organizations to which the current organization ships and receives.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FROM_ORGANIZATION_ID | NUMBER | Yes | ||
TO_ORGANIZATION_ID | NUMBER | Yes | ||
_LA:TRANSFER_TYPE | CHAR | (56) | ||
_LA:FOB_POINT | CHAR | (51) | ||
RECEIPT_ROUTING | NUMBER | |||
_LA:INTERNAL_ORDER_REQUIRED | CHAR | (67) | ||
_LA:TRANSFER_CHARGE_TYPE | CHAR | (78) | ||
TRANSFER_CHARGE_PERCENT | NUMBER | |||
INTERORG_DISTANCE_UOM_CODE | VARCHAR2 | (3) | ||
INTERORG_DISTANCE | NUMBER | |||
TRANSFER_CREDIT_ACCOUNT_ID | NUMBER | |||
PURCHASE_PRICE_VAR_ACCOUNT_ID | NUMBER | |||
INTERORG_RCV_ACCOUNT_ID | NUMBER | |||
INTERORG_PAYABLES_ACCOUNT_ID | NUMBER | |||
INTRANSIT_INVENTORY_ACCOUNT_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID
, _LA:TRANSFER_TYPE
, _LA:FOB_POINT
, RECEIPT_ROUTING
, _LA:INTERNAL_ORDER_REQUIRED
, _LA:TRANSFER_CHARGE_TYPE
, TRANSFER_CHARGE_PERCENT
, INTERORG_DISTANCE_UOM_CODE
, INTERORG_DISTANCE
, TRANSFER_CREDIT_ACCOUNT_ID
, PURCHASE_PRICE_VAR_ACCOUNT_ID
, INTERORG_RCV_ACCOUNT_ID
, INTERORG_PAYABLES_ACCOUNT_ID
, INTRANSIT_INVENTORY_ACCOUNT_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.INVBV_INTERORG_SHIPPING_INFO;
APPS.INVBV_INTERORG_SHIPPING_INFO is not referenced by any database object
|
|
|