DBA Data[Home] [Help]

APPS.INV_UI_RCV_LOVS dependencies on MTL_INTERORG_PARAMETERS

Line 988: where organization_id = (SELECT decode(FOB_POINT,1,TO_ORGANIZATION_ID,2, FROM_ORGANIZATION_ID) from mtl_interorg_parameters where TO_ORGANIZATION_ID = p_ToOrganization_Id and from_organization_id =p_FromOrganization_Id )

984: OPEN x_getcarrierLOV FOR
985: select freight_code, description, distribution_account
986: from
987: org_enabled_freight_val_v
988: where organization_id = (SELECT decode(FOB_POINT,1,TO_ORGANIZATION_ID,2, FROM_ORGANIZATION_ID) from mtl_interorg_parameters where TO_ORGANIZATION_ID = p_ToOrganization_Id and from_organization_id =p_FromOrganization_Id )
989: AND freight_code LIKE (p_carrier)
990: order by freight_code;
991: END GET_CARRIER;
992: