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

VIEW: APPS.INVBV_INTERORG_SHIPPING_INFO

Object Details
Object Name: INVBV_INTERORG_SHIPPING_INFO
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.INVBV_INTERORG_SHIPPING_INFO
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


This shows the organizations to which the current organization ships and receives.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.INVBV_INTERORG_SHIPPING_INFO references the following:

SchemaAPPS
SynonymMTL_INTERORG_PARAMETERS

APPS.INVBV_INTERORG_SHIPPING_INFO is not referenced by any database object