Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVFV_INTERORG_SHIPPING_INFO |
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