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: INVFV_INTERORG_SHIPPING_INFO

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

View Text

SELECT MIP.FROM_ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, MIP.TO_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, '_LA:MIP.INTRANSIT_TYPE:MFG_LOOKUPS:ORG_INTRANSIT:MEANING'
, /* LOOKUP */ '_LA:MIP.FOB_POINT:MFG_LOOKUPS:MTL_FOB_POINT:MEANING'
, /* LOOKUP */ MIP.ROUTING_HEADER_ID
, '_LA:MIP.INTERNAL_ORDER_REQUIRED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MIP.MATL_INTERORG_TRANSFER_CODE:MFG_LOOKUPS:MTL_INTER_INV_TRANSFER:MEANING' /* LOOKUP */
, MIP.INTERORG_TRNSFR_CHARGE_PERCENT
, MIP.DISTANCE_UOM_CODE
, MIP.TO_ORGANIZATION_DISTANCE
, MIP.INTERORG_TRANSFER_CR_ACCOUNT
, '_KF:SQLGL:GL#:GLC1'
, /* KEY FLEXFIELD */ MIP.INTERORG_PRICE_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GLC2'
, /* KEY FLEXFIELD */ MIP.INTERORG_RECEIVABLES_ACCOUNT
, '_KF:SQLGL:GL#:GLC3'
, /* KEY FLEXFIELD */ MIP.INTERORG_PAYABLES_ACCOUNT
, '_KF:SQLGL:GL#:GLC4'
, /* KEY FLEXFIELD */ MIP.INTRANSIT_INV_ACCOUNT
, '_KF:SQLGL:GL#:GLC5' /* KEY FLEXFIELD */
, MIP.CREATED_BY
, MIP.CREATION_DATE
, MIP.LAST_UPDATED_BY
, MIP.LAST_UPDATE_DATE
FROM GL_CODE_COMBINATIONS GLC1
, GL_CODE_COMBINATIONS GLC2
, GL_CODE_COMBINATIONS GLC3
, GL_CODE_COMBINATIONS GLC4
, GL_CODE_COMBINATIONS GLC5
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, MTL_INTERORG_PARAMETERS MIP
WHERE MP1.ORGANIZATION_ID = MIP.FROM_ORGANIZATION_ID
AND MP2.ORGANIZATION_ID = MIP.TO_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MIP.FROM_ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = MIP.TO_ORGANIZATION_ID
AND GLC1.CODE_COMBINATION_ID (+) = MIP.INTERORG_TRANSFER_CR_ACCOUNT
AND GLC2.CODE_COMBINATION_ID (+) = MIP.INTERORG_PRICE_VAR_ACCOUNT
AND GLC3.CODE_COMBINATION_ID (+) = MIP.INTERORG_RECEIVABLES_ACCOUNT
AND GLC4.CODE_COMBINATION_ID (+) = MIP.INTERORG_PAYABLES_ACCOUNT
AND GLC5.CODE_COMBINATION_ID (+) = MIP.INTRANSIT_INV_ACCOUNT
AND '_SEC:MIP.FROM_ORGANIZATION_ID' IS NOT NULL
AND '_SEC:MIP.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
FROM_ORGANIZATION_ID
FROM_ORGANIZATION_CODE
FROM_ORGANIZATION_NAME
TO_ORGANIZATION_ID
TO_ORGANIZATION_CODE
TO_ORGANIZATION_NAME
"_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
"_KF:ACC_NO:XFER_CREDIT:_CO"
PURCHASE_PRICE_VAR_ACCOUNT_ID
"_KF:ACC_NO:PUR_PRICE_VAR:_CO"
INTERORG_RCV_ACCOUNT_ID
"_KF:ACC_NO:INTERORG_RCV:_CO"
INTERORG_PAYABLES_ACCOUNT_ID
"_KF:ACC_NO:INTERORG_PAY:_CO"
INTRANSIT_INVENTORY_ACCOUNT_ID
"_KF:ACC_NO:INTRANSIT_INV:_CO"
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE