eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_PAC_ITERATION_PROCESS_PVT dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 2698: cst_cost_group_assignments ccga

2694: SELECT
2695: cost_group_id
2696: , organization_id
2697: FROM
2698: cst_cost_group_assignments ccga
2699: WHERE check_cst_group(ccga.cost_group_id) = 'Y'
2700: ORDER BY cost_group_id;
2701:
2702: cst_group_org_row cst_group_org_cursor%rowtype;

Line 2905: , cst_cost_group_assignments c1

2901: , p_period_id pac_period_id
2902: FROM
2903: mtl_material_transactions mmt
2904: , mtl_parameters mp
2905: , cst_cost_group_assignments c1
2906: , cst_cost_group_assignments c2
2907: WHERE
2908: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
2909: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 2906: , cst_cost_group_assignments c2

2902: FROM
2903: mtl_material_transactions mmt
2904: , mtl_parameters mp
2905: , cst_cost_group_assignments c1
2906: , cst_cost_group_assignments c2
2907: WHERE
2908: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
2909: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2910: AND nvl(mmt.owning_tp_type,2) = 2

Line 2919: FROM cst_cost_group_assignments ccga1

2915: AND c1.cost_group_id <> c2.cost_group_id
2916: AND (
2917: (mmt.transaction_action_id = 3 AND mmt.transaction_source_type_id = 13
2918: AND EXISTS ( SELECT 'X'
2919: FROM cst_cost_group_assignments ccga1
2920: WHERE ccga1.cost_group_id = p_cost_group_id
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

Line 2926: cst_cost_group_assignments ccga2

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
2930: AND ccga2.organization_id = mip.to_organization_id

Line 2935: cst_cost_group_assignments ccga3

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
2939: AND ccga3.organization_id = mip.to_organization_id

Line 2967: , cst_cost_group_assignments c1

2963: , p_period_id pac_period_id
2964: FROM
2965: mtl_material_transactions mmt
2966: , mtl_parameters mp
2967: , cst_cost_group_assignments c1
2968: , cst_cost_group_assignments c2
2969: WHERE
2970: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
2971: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)

Line 2968: , cst_cost_group_assignments c2

2964: FROM
2965: mtl_material_transactions mmt
2966: , mtl_parameters mp
2967: , cst_cost_group_assignments c1
2968: , cst_cost_group_assignments c2
2969: WHERE
2970: mmt.transaction_date BETWEEN p_period_start_date AND p_period_end_date
2971: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
2972: AND nvl(mmt.owning_tp_type,2) = 2

Line 2996: FROM cst_cost_group_assignments ccga1

2992: AND hoi2.org_information_context = 'Accounting Information'))
2993: AND (
2994: (mmt.transaction_action_id = 3 AND transaction_source_type_id IN (7,8)
2995: AND EXISTS ( SELECT 'X'
2996: FROM cst_cost_group_assignments ccga1
2997: WHERE ccga1.cost_group_id = p_cost_group_id
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)

Line 3003: cst_cost_group_assignments ccga2

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
3007: AND ccga2.organization_id = mip.to_organization_id

Line 3012: cst_cost_group_assignments ccga3

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
3016: AND ccga3.organization_id = mip.to_organization_id

Line 3079: FROM cst_cost_group_assignments ccga

3075: AND mmt.organization_id = mp.organization_id
3076: AND nvl(mp.process_enabled_flag, 'N') = 'N'
3077: AND (transaction_action_id in (3,12,21) AND transaction_source_type_id = 13
3078: AND EXISTS (SELECT 'EXISTS'
3079: FROM cst_cost_group_assignments ccga
3080: WHERE ccga.cost_group_id = p_cost_group_id
3081: AND (ccga.organization_id = mmt.organization_id OR
3082: ccga.organization_id = mmt.transfer_organization_id)))
3083: AND mptrans.organization_id = mmt.transfer_organization_id

Line 3088: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3084: AND mptrans.process_enabled_flag = 'N'
3085: AND (transaction_action_id IN (3,12,21)
3086: AND NOT EXISTS (
3087: SELECT 'X'
3088: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3089: WHERE c1.organization_id = mmt.organization_id
3090: AND c2.organization_id = mmt.transfer_organization_id
3091: AND c1.cost_group_id = c2.cost_group_id)
3092: AND (

Line 3096: FROM cst_cost_group_assignments ccga1

3092: AND (
3093: (mmt.transaction_action_id = 3
3094: AND EXISTS (
3095: SELECT 'X'
3096: FROM cst_cost_group_assignments ccga1
3097: WHERE ccga1.cost_group_id = p_cost_group_id
3098: AND ccga1.organization_id = mmt.organization_id
3099: AND mmt.primary_quantity < 0))
3100: OR (mmt.transaction_action_id = 21

Line 3103: FROM cst_cost_group_assignments ccga2

3099: AND mmt.primary_quantity < 0))
3100: OR (mmt.transaction_action_id = 21
3101: AND EXISTS (
3102: SELECT 'X'
3103: FROM cst_cost_group_assignments ccga2
3104: WHERE ccga2.organization_id = mmt.organization_id
3105: AND ccga2.cost_group_id = p_cost_group_id))
3106: OR (mmt.transaction_action_id = 12
3107: AND EXISTS (

Line 3115: FROM cst_cost_group_assignments ccga2

3111: AND mip.to_organization_id = mmt.organization_id
3112: AND (
3113: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (
3114: SELECT 'X'
3115: FROM cst_cost_group_assignments ccga2
3116: WHERE ccga2.organization_id = mip.to_organization_id
3117: AND ccga2.cost_group_id = p_cost_group_id ))
3118: OR (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3119: SELECT 'X'

Line 3120: FROM cst_cost_group_assignments ccga3

3116: WHERE ccga2.organization_id = mip.to_organization_id
3117: AND ccga2.cost_group_id = p_cost_group_id ))
3118: OR (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3119: SELECT 'X'
3120: FROM cst_cost_group_assignments ccga3
3121: WHERE ccga3.organization_id = mip.from_organization_id
3122: AND ccga3.cost_group_id = p_cost_group_id )))))
3123: ))
3124: UNION

Line 3158: FROM cst_cost_group_assignments ccga

3154: AND mmt1.organization_id = mp1.organization_id
3155: AND nvl(mp1.process_enabled_flag, 'N') = 'N'
3156: AND (mmt1.transaction_action_id in (3,12,21) AND mmt1.transaction_source_type_id IN (7,8)
3157: AND EXISTS (SELECT 'EXISTS'
3158: FROM cst_cost_group_assignments ccga
3159: WHERE ccga.cost_group_id = p_cost_group_id
3160: AND (ccga.organization_id = mmt1.organization_id OR
3161: ccga.organization_id = mmt1.transfer_organization_id)))
3162: AND mptrans1.organization_id = mmt1.transfer_organization_id

Line 3182: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3178: AND hoi2.org_information_context = 'Accounting Information'))
3179: AND (mmt1.transaction_action_id IN (3,12,21) AND mmt1.transaction_source_type_id IN (7,8)
3180: AND NOT EXISTS (
3181: SELECT 'X'
3182: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3183: WHERE c1.organization_id = mmt1.organization_id
3184: AND c2.organization_id = mmt1.transfer_organization_id
3185: AND c1.cost_group_id = c2.cost_group_id)
3186: AND (

Line 3190: FROM cst_cost_group_assignments ccga1

3186: AND (
3187: (mmt1.transaction_action_id = 3
3188: AND EXISTS (
3189: SELECT 'X'
3190: FROM cst_cost_group_assignments ccga1
3191: WHERE ccga1.cost_group_id = p_cost_group_id
3192: AND ccga1.organization_id = mmt1.organization_id
3193: AND mmt1.primary_quantity < 0))
3194: OR (mmt1.transaction_action_id = 21

Line 3197: FROM cst_cost_group_assignments ccga2

3193: AND mmt1.primary_quantity < 0))
3194: OR (mmt1.transaction_action_id = 21
3195: AND EXISTS (
3196: SELECT 'X'
3197: FROM cst_cost_group_assignments ccga2
3198: WHERE ccga2.organization_id = mmt1.organization_id
3199: AND ccga2.cost_group_id = p_cost_group_id))
3200: OR (mmt1.transaction_action_id = 12
3201: AND EXISTS (

Line 3209: FROM cst_cost_group_assignments ccga2

3205: AND mip.to_organization_id = mmt1.organization_id
3206: AND (
3207: (NVL(mmt1.fob_point,mip.fob_point) = 1 AND EXISTS (
3208: SELECT 'X'
3209: FROM cst_cost_group_assignments ccga2
3210: WHERE ccga2.organization_id = mip.to_organization_id
3211: AND ccga2.cost_group_id = p_cost_group_id ))
3212: OR (NVL(mmt1.fob_point,mip.fob_point) = 2 AND EXISTS (
3213: SELECT 'X'

Line 3214: FROM cst_cost_group_assignments ccga3

3210: WHERE ccga2.organization_id = mip.to_organization_id
3211: AND ccga2.cost_group_id = p_cost_group_id ))
3212: OR (NVL(mmt1.fob_point,mip.fob_point) = 2 AND EXISTS (
3213: SELECT 'X'
3214: FROM cst_cost_group_assignments ccga3
3215: WHERE ccga3.organization_id = mip.from_organization_id
3216: AND ccga3.cost_group_id = p_cost_group_id )))))
3217: )));
3218: