Product: | INV - Inventory |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.INVBV_INTERORG_SHIPPING_INFO |
SELECT MIP.FROM_ORGANIZATION_ID
, MIP.TO_ORGANIZATION_ID
, '_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
, MIP.INTERORG_PRICE_VAR_ACCOUNT
, MIP.INTERORG_RECEIVABLES_ACCOUNT
, MIP.INTERORG_PAYABLES_ACCOUNT
, MIP.INTRANSIT_INV_ACCOUNT
, MIP.CREATED_BY
, MIP.CREATION_DATE
, MIP.LAST_UPDATED_BY
, MIP.LAST_UPDATE_DATE
FROM MTL_INTERORG_PARAMETERS MIP
WHERE '_SEC:MIP.FROM_ORGANIZATION_ID' IS NOT NULL
AND '_SEC:MIP.TO_ORGANIZATION_ID' IS NOT NULL WITH READ ONLY