VIEW: APPS.INVFV_INTERORG_SHIPPING_INFO

Source

View Text - Preformatted

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

View Text - HTML Formatted

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