DBA Data[Home] [Help]

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 2925: FROM mtl_interorg_parameters mip,

2921: AND ccga1.organization_id = mmt.organization_id
2922: AND mmt.primary_quantity > 0))
2923: OR (mmt.transaction_action_id = 21 AND mmt.transaction_source_type_id = 13
2924: AND EXISTS ( SELECT 'X'
2925: FROM mtl_interorg_parameters mip,
2926: cst_cost_group_assignments ccga2
2927: WHERE mip.from_organization_id = mmt.organization_id
2928: AND mip.to_organization_id = mmt.transfer_organization_id
2929: AND nvl(mmt.fob_point,mip.fob_point) = 1

Line 2934: FROM mtl_interorg_parameters mip,

2930: AND ccga2.organization_id = mip.to_organization_id
2931: AND ccga2.cost_group_id = p_cost_group_id))
2932: OR (mmt.transaction_action_id = 12 AND mmt.transaction_source_type_id = 13
2933: AND EXISTS ( SELECT 'X'
2934: FROM mtl_interorg_parameters mip,
2935: cst_cost_group_assignments ccga3
2936: WHERE mip.from_organization_id = mmt.transfer_organization_id
2937: AND mip.to_organization_id = mmt.organization_id
2938: AND nvl(mmt.fob_point,mip.fob_point) = 2

Line 3002: FROM mtl_interorg_parameters mip,

2998: AND ccga1.organization_id = mmt.organization_id
2999: AND mmt.primary_quantity > 0))
3000: OR (mmt.transaction_action_id = 21 AND transaction_source_type_id IN (7,8)
3001: AND EXISTS ( SELECT 'X'
3002: FROM mtl_interorg_parameters mip,
3003: cst_cost_group_assignments ccga2
3004: WHERE mip.from_organization_id = mmt.organization_id
3005: AND mip.to_organization_id = mmt.transfer_organization_id
3006: AND nvl(mmt.fob_point,mip.fob_point) = 1

Line 3011: FROM mtl_interorg_parameters mip,

3007: AND ccga2.organization_id = mip.to_organization_id
3008: AND ccga2.cost_group_id = p_cost_group_id))
3009: OR (mmt.transaction_action_id = 12 AND mmt.transaction_source_type_id IN (7,8)
3010: AND EXISTS ( SELECT 'X'
3011: FROM mtl_interorg_parameters mip,
3012: cst_cost_group_assignments ccga3
3013: WHERE mip.from_organization_id = mmt.transfer_organization_id
3014: AND mip.to_organization_id = mmt.organization_id
3015: AND nvl(mmt.fob_point,mip.fob_point) = 2

Line 3109: FROM mtl_interorg_parameters mip

3105: AND ccga2.cost_group_id = p_cost_group_id))
3106: OR (mmt.transaction_action_id = 12
3107: AND EXISTS (
3108: SELECT 'X'
3109: FROM mtl_interorg_parameters mip
3110: WHERE mip.from_organization_id = mmt.transfer_organization_id
3111: AND mip.to_organization_id = mmt.organization_id
3112: AND (
3113: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (

Line 3203: FROM mtl_interorg_parameters mip

3199: AND ccga2.cost_group_id = p_cost_group_id))
3200: OR (mmt1.transaction_action_id = 12
3201: AND EXISTS (
3202: SELECT 'X'
3203: FROM mtl_interorg_parameters mip
3204: WHERE mip.from_organization_id = mmt1.transfer_organization_id
3205: AND mip.to_organization_id = mmt1.organization_id
3206: AND (
3207: (NVL(mmt1.fob_point,mip.fob_point) = 1 AND EXISTS (