eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: MTL_SHIPPING_NETWORK_VIEW

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.MTL_SHIPPING_NETWORK_VIEW

View Text

SELECT NET.ROWID ROW_ID
, MP1.ORGANIZATION_CODE FROM_ORGANIZATION_CODE
, HOU1.NAME FROM_ORGANIZATION_NAME
, MP1.PRIMARY_COST_METHOD FROM_PRIMARY_COST_DUMMY
, MP1.INTERORG_TRNSFR_CHARGE_PERCENT FROM_CHARGE_PERCENT_DUMMY
, MP2.ORGANIZATION_CODE TO_ORGANIZATION_CODE
, HOU2.NAME TO_ORGANIZATION_NAME
, MP2.PRIMARY_COST_METHOD TO_PRIMARY_COST_DUMMY
, NET.FROM_ORGANIZATION_ID
, NET.TO_ORGANIZATION_ID
, NET.LAST_UPDATE_DATE
, NET.LAST_UPDATED_BY
, NET.CREATION_DATE
, NET.CREATED_BY
, NET.LAST_UPDATE_LOGIN
, NET.INTRANSIT_TYPE
, NET.DISTANCE_UOM_CODE
, NET.TO_ORGANIZATION_DISTANCE
, NET.MATL_INTERORG_TRANSFER_CODE
, NET.INTERORG_TRNSFR_CHARGE_PERCENT
, NET.FOB_POINT
, NET.ROUTING_HEADER_ID
, NET.INTERNAL_ORDER_REQUIRED_FLAG
, NET.INTRANSIT_INV_ACCOUNT
, NET.INTERORG_TRANSFER_CR_ACCOUNT
, NET.INTERORG_RECEIVABLES_ACCOUNT
, NET.INTERORG_PAYABLES_ACCOUNT
, NET.INTERORG_PRICE_VAR_ACCOUNT
, NET.ATTRIBUTE_CATEGORY
, NET.ATTRIBUTE1
, NET.ATTRIBUTE2
, NET.ATTRIBUTE3
, NET.ATTRIBUTE4
, NET.ATTRIBUTE5
, NET.ATTRIBUTE6
, NET.ATTRIBUTE7
, NET.ATTRIBUTE8
, NET.ATTRIBUTE9
, NET.ATTRIBUTE10
, NET.ATTRIBUTE11
, NET.ATTRIBUTE12
, NET.ATTRIBUTE13
, NET.ATTRIBUTE14
, NET.ATTRIBUTE15
, DECODE( NET.ELEMENTAL_VISIBILITY_ENABLED
, NULL
, 'N'
, NET.ELEMENTAL_VISIBILITY_ENABLED) ELEMENTAL_VISIBILITY_ENABLED
, NET.MANUAL_RECEIPT_EXPENSE
, NET.PROFIT_IN_INV_ACCOUNT
, NET.SUBCONTRACTING_TYPE
, NET.SHIKYU_DEFAULT_ORDER_TYPE_ID
, NET.SHIKYU_OEM_VAR_ACCOUNT_ID
, NET.SHIKYU_TP_OFFSET_ACCOUNT_ID
, NET.PRICELIST_ID
, NET.INTERORG_PROFIT_ACCOUNT
, HOU1.LOCATION_ID FROM_LOCATION_ID
, HOU2.LOCATION_ID TO_LOCATION_ID
FROM MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ORGANIZATION_UNITS HOU1
, HR_ORGANIZATION_UNITS HOU2
, MTL_INTERORG_PARAMETERS NET
WHERE MP1.ORGANIZATION_ID = NET.FROM_ORGANIZATION_ID
AND MP2.ORGANIZATION_ID = NET.TO_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MP1.ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = MP2.ORGANIZATION_ID

Columns

Name
ROW_ID
FROM_ORGANIZATION_CODE
FROM_ORGANIZATION_NAME
FROM_PRIMARY_COST_DUMMY
FROM_CHARGE_PERCENT_DUMMY
TO_ORGANIZATION_CODE
TO_ORGANIZATION_NAME
TO_PRIMARY_COST_DUMMY
FROM_ORGANIZATION_ID
TO_ORGANIZATION_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
INTRANSIT_TYPE
DISTANCE_UOM_CODE
TO_ORGANIZATION_DISTANCE
MATL_INTERORG_TRANSFER_CODE
INTERORG_TRNSFR_CHARGE_PERCENT
FOB_POINT
ROUTING_HEADER_ID
INTERNAL_ORDER_REQUIRED_FLAG
INTRANSIT_INV_ACCOUNT
INTERORG_TRANSFER_CR_ACCOUNT
INTERORG_RECEIVABLES_ACCOUNT
INTERORG_PAYABLES_ACCOUNT
INTERORG_PRICE_VAR_ACCOUNT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ELEMENTAL_VISIBILITY_ENABLED
MANUAL_RECEIPT_EXPENSE
PROFIT_IN_INV_ACCOUNT
SUBCONTRACTING_TYPE
SHIKYU_DEFAULT_ORDER_TYPE_ID
SHIKYU_OEM_VAR_ACCOUNT_ID
SHIKYU_TP_OFFSET_ACCOUNT_ID
PRICELIST_ID
INTERORG_PROFIT_ACCOUNT
FROM_LOCATION_ID
TO_LOCATION_ID