VIEW: APPS.INVBV_INTERORG_SHIPPING_INFO

Source

View Text - Preformatted

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

View Text - HTML Formatted

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