DBA Data[Home] [Help]

APPS.INV_TRANSACTION_LOVS dependencies on MTL_INTERORG_PARAMETERS

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

19: OPEN x_getcarrierLOV FOR
20: select freight_code, description, distribution_account
21: from
22: org_enabled_freight_val_v
23: where organization_id = (SELECT decode(FOB_POINT,1,TO_ORGANIZATION_ID,2, FROM_ORGANIZATION_ID) from mtl_interorg_parameters where TO_ORGANIZATION_ID = p_FromOrganization_Id and from_organization_id =p_ToOrganization_Id )
24: AND freight_code LIKE p_carrier
25: order by freight_code;
26: END GET_CARRIER;
27:

Line 458: FROM mtl_interorg_parameters a, mtl_parameters b,hr_all_organization_units c

454: BEGIN
455: OPEN x_Organizations FOR
456: SELECT
457: a.to_organization_id,b.organization_code,c.name, a.intransit_type
458: FROM mtl_interorg_parameters a, mtl_parameters b,hr_all_organization_units c
459: WHERE a.from_organization_id = p_From_Organization_Id AND
460: a.to_organization_id = b.organization_id
461: AND a.to_organization_id = c.organization_id
462: order by 2;