DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 3076: FROM mtl_interorg_parameters mip,

3072: AND ccga1.organization_id = mmt.organization_id
3073: AND mmt.primary_quantity > 0))
3074: OR (mmt.transaction_action_id = 21 AND mmt.transaction_source_type_id = 13
3075: AND EXISTS ( SELECT 'X'
3076: FROM mtl_interorg_parameters mip,
3077: cst_cost_group_assignments ccga2
3078: WHERE mip.from_organization_id = mmt.organization_id
3079: AND mip.to_organization_id = mmt.transfer_organization_id
3080: AND nvl(mmt.fob_point,mip.fob_point) = 1

Line 3085: FROM mtl_interorg_parameters mip,

3081: AND ccga2.organization_id = mip.to_organization_id
3082: AND ccga2.cost_group_id = p_cost_group_id))
3083: OR (mmt.transaction_action_id = 12 AND mmt.transaction_source_type_id = 13
3084: AND EXISTS ( SELECT 'X'
3085: FROM mtl_interorg_parameters mip,
3086: cst_cost_group_assignments ccga3
3087: WHERE mip.from_organization_id = mmt.transfer_organization_id
3088: AND mip.to_organization_id = mmt.organization_id
3089: AND nvl(mmt.fob_point,mip.fob_point) = 2

Line 3158: FROM mtl_interorg_parameters mip,

3154: AND ccga1.organization_id = mmt.organization_id
3155: AND mmt.primary_quantity > 0))
3156: OR (mmt.transaction_action_id = 21 AND transaction_source_type_id IN (7,8)
3157: AND EXISTS ( SELECT 'X'
3158: FROM mtl_interorg_parameters mip,
3159: cst_cost_group_assignments ccga2
3160: WHERE mip.from_organization_id = mmt.organization_id
3161: AND mip.to_organization_id = mmt.transfer_organization_id
3162: AND nvl(mmt.fob_point,mip.fob_point) = 1

Line 3167: FROM mtl_interorg_parameters mip,

3163: AND ccga2.organization_id = mip.to_organization_id
3164: AND ccga2.cost_group_id = p_cost_group_id))
3165: OR (mmt.transaction_action_id = 12 AND mmt.transaction_source_type_id IN (7,8)
3166: AND EXISTS ( SELECT 'X'
3167: FROM mtl_interorg_parameters mip,
3168: cst_cost_group_assignments ccga3
3169: WHERE mip.from_organization_id = mmt.transfer_organization_id
3170: AND mip.to_organization_id = mmt.organization_id
3171: AND nvl(mmt.fob_point,mip.fob_point) = 2

Line 3265: FROM mtl_interorg_parameters mip

3261: AND ccga2.cost_group_id = p_cost_group_id))
3262: OR (mmt.transaction_action_id = 12
3263: AND EXISTS (
3264: SELECT 'X'
3265: FROM mtl_interorg_parameters mip
3266: WHERE mip.from_organization_id = mmt.transfer_organization_id
3267: AND mip.to_organization_id = mmt.organization_id
3268: AND (
3269: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (

Line 3359: FROM mtl_interorg_parameters mip

3355: AND ccga2.cost_group_id = p_cost_group_id))
3356: OR (mmt1.transaction_action_id = 12
3357: AND EXISTS (
3358: SELECT 'X'
3359: FROM mtl_interorg_parameters mip
3360: WHERE mip.from_organization_id = mmt1.transfer_organization_id
3361: AND mip.to_organization_id = mmt1.organization_id
3362: AND (
3363: (NVL(mmt1.fob_point,mip.fob_point) = 1 AND EXISTS (