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.CSTPPINV dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 111: FROM cst_cost_group_assignments

107:
108: l_stmt_num := 30;
109: SELECT NVL(MAX(cost_group_id),-1)
110: INTO l_txn_cost_group_id
111: FROM cst_cost_group_assignments
112: WHERE organization_id = i_txn_org_id;
113:
114: l_stmt_num := 40;
115: SELECT NVL(MAX(cost_group_id),-1)

Line 117: FROM cst_cost_group_assignments

113:
114: l_stmt_num := 40;
115: SELECT NVL(MAX(cost_group_id),-1)
116: INTO l_txfr_cost_group_id
117: FROM cst_cost_group_assignments
118: WHERE organization_id = i_txfr_org_id;
119:
120: -- Modified for fob stamping project
121: l_stmt_num := 50;

Line 173: FROM cst_cost_group_assignments ccga

169: SET periodic_primary_quantity = l_converted_txn_qty
170: WHERE transaction_id = i_txn_id
171: AND organization_id = i_txn_org_id
172: AND EXISTS ( SELECT 'x'
173: FROM cst_cost_group_assignments ccga
174: WHERE ccga.cost_group_id = i_cost_group_id
175: AND ccga.organization_id = i_txn_org_id);
176:
177:

Line 2462: FROM cst_cost_group_assignments ccga

2458: l_parent_transaction_id)
2459: WHERE transaction_id = i_txn_id
2460: AND organization_id = i_txn_org_id
2461: AND EXISTS (SELECT 'x'
2462: FROM cst_cost_group_assignments ccga
2463: WHERE ccga.cost_group_id = i_cost_group_id
2464: AND ccga.organization_id = i_txn_org_id);
2465:
2466:

Line 2551: FROM cst_cost_group_assignments ccga

2547: SET periodic_primary_quantity = i_txn_qty
2548: WHERE transaction_id = i_txn_id
2549: AND organization_id = i_txn_org_id
2550: AND EXISTS (SELECT 'x'
2551: FROM cst_cost_group_assignments ccga
2552: WHERE ccga.cost_group_id = i_cost_group_id
2553: AND ccga.organization_id = i_txn_org_id);
2554:
2555:

Line 2859: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

2855: AND nvl(mmt.owning_tp_type,2) = 2
2856: AND mmt.organization_id = mp.organization_id
2857: AND nvl(mp.process_enabled_flag,'N') = 'N' --INVCONV sikhanna
2858: AND NOT EXISTS ( SELECT 'X'
2859: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
2860: WHERE c1.organization_id = mmt.organization_id
2861: AND c2.organization_id = mmt.transfer_organization_id
2862: AND c1.cost_group_id = c2.cost_group_id)
2863: AND (

Line 2866: FROM cst_cost_group_assignments ccga1

2862: AND c1.cost_group_id = c2.cost_group_id)
2863: AND (
2864: (mmt.transaction_action_id = 3
2865: AND EXISTS ( SELECT 'X'
2866: FROM cst_cost_group_assignments ccga1
2867: WHERE ccga1.cost_group_id = i_cost_group_id
2868: AND ccga1.organization_id = mmt.organization_id
2869: AND mmt.primary_quantity > 0))
2870: OR (mmt.transaction_action_id = 21

Line 2873: cst_cost_group_assignments ccga2

2869: AND mmt.primary_quantity > 0))
2870: OR (mmt.transaction_action_id = 21
2871: AND EXISTS ( SELECT 'X'
2872: FROM mtl_interorg_parameters mip,
2873: cst_cost_group_assignments ccga2
2874: WHERE mip.from_organization_id = mmt.organization_id
2875: AND mip.to_organization_id = mmt.transfer_organization_id
2876: AND NVL(mmt.fob_point,mip.fob_point) = 1
2877: AND ccga2.organization_id = mip.to_organization_id

Line 2882: cst_cost_group_assignments ccga2

2878: AND ccga2.cost_group_id = i_cost_group_id))
2879: OR (mmt.transaction_action_id = 12
2880: AND EXISTS ( SELECT 'X'
2881: FROM mtl_interorg_parameters mip,
2882: cst_cost_group_assignments ccga2
2883: WHERE mip.from_organization_id = mmt.transfer_organization_id
2884: AND mip.to_organization_id = mmt.organization_id
2885: AND NVL(mmt.fob_point,mip.fob_point) = 2
2886: AND ccga2.organization_id = mip.to_organization_id

Line 2891: FROM cst_cost_group_assignments ccga0

2887: AND ccga2.cost_group_id = i_cost_group_id))
2888: /* Logical Intransit Receipt for receiving organization cost group */ -- INVCONV sikhanna
2889: OR (mmt.transaction_action_id = 15
2890: AND EXISTS ( SELECT 'X'
2891: FROM cst_cost_group_assignments ccga0
2892: WHERE ccga0.organization_id = mmt.organization_id
2893: AND ccga0.cost_group_id = i_cost_group_id))
2894: )
2895: ORDER BY inventory_item_id;

Line 3230: FROM cst_cost_group_assignments ccga

3226: AND mmt.organization_id = mp.organization_id
3227: AND nvl(mp.process_enabled_flag,'N') = 'N'
3228: AND ((transaction_action_id in (3,12,21)
3229: AND EXISTS (SELECT 'EXISTS'
3230: FROM cst_cost_group_assignments ccga
3231: WHERE ccga.cost_group_id = i_cost_group_id
3232: AND (ccga.organization_id = mmt.organization_id OR
3233: ccga.organization_id = mmt.transfer_organization_id)))
3234: /* Logical Intransit Shipment for shipping organization cost group */ -- INVCONV sikhanna

Line 3237: FROM cst_cost_group_assignments ccga0

3233: ccga.organization_id = mmt.transfer_organization_id)))
3234: /* Logical Intransit Shipment for shipping organization cost group */ -- INVCONV sikhanna
3235: OR (mmt.transaction_action_id = 22
3236: AND EXISTS ( SELECT 'X'
3237: FROM cst_cost_group_assignments ccga0
3238: WHERE ccga0.organization_id = mmt.organization_id
3239: AND ccga0.cost_group_id = i_cost_group_id)))
3240: AND (transaction_action_id IN (3,12,21,22)
3241: AND NOT EXISTS (

Line 3243: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3239: AND ccga0.cost_group_id = i_cost_group_id)))
3240: AND (transaction_action_id IN (3,12,21,22)
3241: AND NOT EXISTS (
3242: SELECT 'X'
3243: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3244: WHERE c1.organization_id = mmt.organization_id
3245: AND c2.organization_id = mmt.transfer_organization_id
3246: AND c1.cost_group_id = c2.cost_group_id)
3247: AND (

Line 3251: FROM cst_cost_group_assignments ccga1

3247: AND (
3248: (mmt.transaction_action_id = 3
3249: AND EXISTS (
3250: SELECT 'X'
3251: FROM cst_cost_group_assignments ccga1
3252: WHERE ccga1.cost_group_id = i_cost_group_id
3253: AND ccga1.organization_id = mmt.organization_id
3254: AND mmt.primary_quantity < 0))
3255: OR (mmt.transaction_action_id = 21

Line 3258: FROM cst_cost_group_assignments ccga2

3254: AND mmt.primary_quantity < 0))
3255: OR (mmt.transaction_action_id = 21
3256: AND EXISTS (
3257: SELECT 'X'
3258: FROM cst_cost_group_assignments ccga2
3259: WHERE ccga2.organization_id = mmt.organization_id
3260: AND ccga2.cost_group_id = i_cost_group_id))
3261: OR (mmt.transaction_action_id = 12
3262: AND EXISTS (

Line 3270: FROM cst_cost_group_assignments ccga2

3266: AND mip.to_organization_id = mmt.organization_id
3267: AND (
3268: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (
3269: SELECT 'X'
3270: FROM cst_cost_group_assignments ccga2
3271: WHERE ccga2.organization_id = mip.to_organization_id
3272: AND ccga2.cost_group_id = i_cost_group_id ))
3273: Or (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3274: SELECT 'X'

Line 3275: FROM cst_cost_group_assignments ccga3

3271: WHERE ccga2.organization_id = mip.to_organization_id
3272: AND ccga2.cost_group_id = i_cost_group_id ))
3273: Or (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3274: SELECT 'X'
3275: FROM cst_cost_group_assignments ccga3
3276: WHERE ccga3.organization_id = mip.from_organization_id
3277: AND ccga3.cost_group_id = i_cost_group_id )))))
3278: /* Logical Intransit Shipment for shipping organization cost group */
3279: OR (mmt.transaction_action_id = 22

Line 3281: FROM cst_cost_group_assignments ccga0

3277: AND ccga3.cost_group_id = i_cost_group_id )))))
3278: /* Logical Intransit Shipment for shipping organization cost group */
3279: OR (mmt.transaction_action_id = 22
3280: AND EXISTS ( SELECT 'X'
3281: FROM cst_cost_group_assignments ccga0
3282: WHERE ccga0.organization_id = mmt.organization_id
3283: AND ccga0.cost_group_id = i_cost_group_id))
3284: ))
3285: AND NOT EXISTS (

Line 3629: FROM cst_cost_group_assignments ccga

3625: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3626: AND nvl(mmt.owning_tp_type,2) = 2
3627: and transaction_action_id in (3,12,21)
3628: AND EXISTS (SELECT 'EXISTS'
3629: FROM cst_cost_group_assignments ccga
3630: WHERE ccga.cost_group_id = i_cost_group_id
3631: AND (ccga.organization_id = mmt.organization_id OR
3632: ccga.organization_id = mmt.transfer_organization_id))
3633: AND

Line 3639: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3635: (transaction_action_id IN (12,21)
3636: OR (transaction_action_id = 3 AND primary_quantity < 0))
3637: AND EXISTS (
3638: SELECT 'X'
3639: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3640: WHERE c1.organization_id = mmt.organization_id
3641: AND c2.organization_id = mmt.transfer_organization_id
3642: AND c1.cost_group_id = c2.cost_group_id))
3643: AND NOT EXISTS (

Line 3661: cst_cost_group_assignments ccga

3657: nvl(mmt.transfer_organization_id,-1),
3658: mmt.subinventory_code
3659: FROM
3660: mtl_material_transactions mmt,
3661: cst_cost_group_assignments ccga
3662: WHERE
3663: transaction_date between l_start_date AND l_end_date
3664: AND transaction_action_id in (4,8,28,33,34,1,2,5,27) /* Added VMI Planning Transfer */
3665: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)