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.

[Home] [Help]

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 343: FROM cst_cost_group_assignments CCGA

339: WHERE MMT.transaction_id = i_txn_id
340: AND RMA.line_id = MMT.trx_source_line_id
341: /* Bug 8236035 */
342: AND EXISTS (SELECT 1
343: FROM cst_cost_group_assignments CCGA
344: WHERE CCGA.cost_group_id = i_cost_group_id
345: AND CCGA.organization_id = MMT.organization_id);
346:
347: -- If the RMA references a sales order issue, and if the

Line 376: FROM cst_cost_group_assignments CCGA

372: mtl_pac_actual_cost_details MPACD
373: WHERE (MMT.transaction_action_id = 1 OR MMT.transaction_action_id = 7)
374: AND MMT.transaction_source_type_id = 2
375: AND EXISTS (SELECT 1
376: FROM cst_cost_group_assignments CCGA
377: WHERE CCGA.cost_group_id = i_cost_group_id
378: AND CCGA.organization_id = MMT.organization_id)
379: AND MMT.inventory_item_id = i_item_id
380: AND MMT.trx_source_line_id = l_so_line_id

Line 430: FROM cst_cost_group_assignments CCGA

426: AND MMT.transaction_source_type_id = 2
427: /* Bug 8236035
428: AND MMT.organization_id = i_txn_org_id*/
429: AND EXISTS (SELECT 1
430: FROM cst_cost_group_assignments CCGA
431: WHERE CCGA.cost_group_id = i_cost_group_id
432: AND CCGA.organization_id = MMT.organization_id)
433: AND MMT.inventory_item_id = i_item_id
434: AND MMT.trx_source_line_id = l_so_line_id

Line 487: FROM cst_cost_group_assignments CCGA

483: AND MMT.transaction_source_type_id = 2
484: /* Bug 8236035
485: AND MMT.organization_id = i_txn_org_id*/
486: AND EXISTS (SELECT 1
487: FROM cst_cost_group_assignments CCGA
488: WHERE CCGA.cost_group_id = i_cost_group_id
489: AND CCGA.organization_id = MMT.organization_id)
490: AND MMT.inventory_item_id = i_item_id
491: AND MMT.trx_source_line_id = l_so_line_id

Line 2504: FROM cst_cost_group_assignments ccga

2500: l_parent_transaction_id)
2501: WHERE transaction_id = i_txn_id
2502: AND organization_id = i_txn_org_id
2503: AND EXISTS (SELECT 'x'
2504: FROM cst_cost_group_assignments ccga
2505: WHERE ccga.cost_group_id = i_cost_group_id
2506: AND ccga.organization_id = i_txn_org_id);
2507:
2508:

Line 2593: FROM cst_cost_group_assignments ccga

2589: SET periodic_primary_quantity = i_txn_qty
2590: WHERE transaction_id = i_txn_id
2591: AND organization_id = i_txn_org_id
2592: AND EXISTS (SELECT 'x'
2593: FROM cst_cost_group_assignments ccga
2594: WHERE ccga.cost_group_id = i_cost_group_id
2595: AND ccga.organization_id = i_txn_org_id);
2596:
2597:

Line 2909: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

2905: AND nvl(mmt.owning_tp_type,2) = 2
2906: AND mmt.organization_id = mp.organization_id
2907: AND nvl(mp.process_enabled_flag,'N') = 'N' --INVCONV sikhanna
2908: AND NOT EXISTS ( SELECT 'X'
2909: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
2910: WHERE c1.organization_id = mmt.organization_id
2911: AND c2.organization_id = mmt.transfer_organization_id
2912: AND c1.cost_group_id = c2.cost_group_id)
2913: AND (

Line 2916: FROM cst_cost_group_assignments ccga1

2912: AND c1.cost_group_id = c2.cost_group_id)
2913: AND (
2914: (mmt.transaction_action_id = 3
2915: AND EXISTS ( SELECT 'X'
2916: FROM cst_cost_group_assignments ccga1
2917: WHERE ccga1.cost_group_id = i_cost_group_id
2918: AND ccga1.organization_id = mmt.organization_id
2919: AND mmt.primary_quantity > 0))
2920: OR (mmt.transaction_action_id = 21

Line 2923: cst_cost_group_assignments ccga2

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

Line 2932: cst_cost_group_assignments ccga2

2928: AND ccga2.cost_group_id = i_cost_group_id))
2929: OR (mmt.transaction_action_id = 12
2930: AND EXISTS ( SELECT 'X'
2931: FROM mtl_interorg_parameters mip,
2932: cst_cost_group_assignments ccga2
2933: WHERE mip.from_organization_id = mmt.transfer_organization_id
2934: AND mip.to_organization_id = mmt.organization_id
2935: AND NVL(mmt.fob_point,mip.fob_point) = 2
2936: AND ccga2.organization_id = mip.to_organization_id

Line 2941: FROM cst_cost_group_assignments ccga0

2937: AND ccga2.cost_group_id = i_cost_group_id))
2938: /* Logical Intransit Receipt for receiving organization cost group */ -- INVCONV sikhanna
2939: OR (mmt.transaction_action_id = 15
2940: AND EXISTS ( SELECT 'X'
2941: FROM cst_cost_group_assignments ccga0
2942: WHERE ccga0.organization_id = mmt.organization_id
2943: AND ccga0.cost_group_id = i_cost_group_id))
2944: )
2945: ORDER BY inventory_item_id;

Line 3282: FROM cst_cost_group_assignments ccga

3278: AND mmt.organization_id = mp.organization_id
3279: AND nvl(mp.process_enabled_flag,'N') = 'N'
3280: AND ((transaction_action_id in (3,12,21)
3281: AND EXISTS (SELECT 'EXISTS'
3282: FROM cst_cost_group_assignments ccga
3283: WHERE ccga.cost_group_id = i_cost_group_id
3284: AND (ccga.organization_id = mmt.organization_id OR
3285: ccga.organization_id = mmt.transfer_organization_id)))
3286: /* Logical Intransit Shipment for shipping organization cost group */ -- INVCONV sikhanna

Line 3289: FROM cst_cost_group_assignments ccga0

3285: ccga.organization_id = mmt.transfer_organization_id)))
3286: /* Logical Intransit Shipment for shipping organization cost group */ -- INVCONV sikhanna
3287: OR (mmt.transaction_action_id = 22
3288: AND EXISTS ( SELECT 'X'
3289: FROM cst_cost_group_assignments ccga0
3290: WHERE ccga0.organization_id = mmt.organization_id
3291: AND ccga0.cost_group_id = i_cost_group_id)))
3292: AND (transaction_action_id IN (3,12,21,22)
3293: AND NOT EXISTS (

Line 3295: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3291: AND ccga0.cost_group_id = i_cost_group_id)))
3292: AND (transaction_action_id IN (3,12,21,22)
3293: AND NOT EXISTS (
3294: SELECT 'X'
3295: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3296: WHERE c1.organization_id = mmt.organization_id
3297: AND c2.organization_id = mmt.transfer_organization_id
3298: AND c1.cost_group_id = c2.cost_group_id)
3299: AND (

Line 3303: FROM cst_cost_group_assignments ccga1

3299: AND (
3300: (mmt.transaction_action_id = 3
3301: AND EXISTS (
3302: SELECT 'X'
3303: FROM cst_cost_group_assignments ccga1
3304: WHERE ccga1.cost_group_id = i_cost_group_id
3305: AND ccga1.organization_id = mmt.organization_id
3306: AND mmt.primary_quantity < 0))
3307: OR (mmt.transaction_action_id = 21

Line 3310: FROM cst_cost_group_assignments ccga2

3306: AND mmt.primary_quantity < 0))
3307: OR (mmt.transaction_action_id = 21
3308: AND EXISTS (
3309: SELECT 'X'
3310: FROM cst_cost_group_assignments ccga2
3311: WHERE ccga2.organization_id = mmt.organization_id
3312: AND ccga2.cost_group_id = i_cost_group_id))
3313: OR (mmt.transaction_action_id = 12
3314: AND EXISTS (

Line 3322: FROM cst_cost_group_assignments ccga2

3318: AND mip.to_organization_id = mmt.organization_id
3319: AND (
3320: (NVL(mmt.fob_point,mip.fob_point) = 1 AND EXISTS (
3321: SELECT 'X'
3322: FROM cst_cost_group_assignments ccga2
3323: WHERE ccga2.organization_id = mip.to_organization_id
3324: AND ccga2.cost_group_id = i_cost_group_id ))
3325: Or (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3326: SELECT 'X'

Line 3327: FROM cst_cost_group_assignments ccga3

3323: WHERE ccga2.organization_id = mip.to_organization_id
3324: AND ccga2.cost_group_id = i_cost_group_id ))
3325: Or (NVL(mmt.fob_point,mip.fob_point) = 2 AND EXISTS (
3326: SELECT 'X'
3327: FROM cst_cost_group_assignments ccga3
3328: WHERE ccga3.organization_id = mip.from_organization_id
3329: AND ccga3.cost_group_id = i_cost_group_id )))))
3330: /* Logical Intransit Shipment for shipping organization cost group */
3331: OR (mmt.transaction_action_id = 22

Line 3333: FROM cst_cost_group_assignments ccga0

3329: AND ccga3.cost_group_id = i_cost_group_id )))))
3330: /* Logical Intransit Shipment for shipping organization cost group */
3331: OR (mmt.transaction_action_id = 22
3332: AND EXISTS ( SELECT 'X'
3333: FROM cst_cost_group_assignments ccga0
3334: WHERE ccga0.organization_id = mmt.organization_id
3335: AND ccga0.cost_group_id = i_cost_group_id))
3336: ))
3337: AND NOT EXISTS (

Line 3681: FROM cst_cost_group_assignments ccga

3677: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)
3678: AND nvl(mmt.owning_tp_type,2) = 2
3679: and transaction_action_id in (3,12,21)
3680: AND EXISTS (SELECT 'EXISTS'
3681: FROM cst_cost_group_assignments ccga
3682: WHERE ccga.cost_group_id = i_cost_group_id
3683: AND (ccga.organization_id = mmt.organization_id OR
3684: ccga.organization_id = mmt.transfer_organization_id))
3685: AND

Line 3691: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2

3687: (transaction_action_id IN (12,21)
3688: OR (transaction_action_id = 3 AND primary_quantity < 0))
3689: AND EXISTS (
3690: SELECT 'X'
3691: FROM cst_cost_group_assignments c1, cst_cost_group_assignments c2
3692: WHERE c1.organization_id = mmt.organization_id
3693: AND c2.organization_id = mmt.transfer_organization_id
3694: AND c1.cost_group_id = c2.cost_group_id))
3695: AND NOT EXISTS (

Line 3713: cst_cost_group_assignments ccga

3709: nvl(mmt.transfer_organization_id,-1),
3710: mmt.subinventory_code
3711: FROM
3712: mtl_material_transactions mmt,
3713: cst_cost_group_assignments ccga
3714: WHERE
3715: transaction_date between l_start_date AND l_end_date
3716: AND transaction_action_id in (4,8,28,33,34,1,2,5,27) /* Added VMI Planning Transfer */
3717: AND mmt.organization_id = nvl(mmt.owning_organization_id, mmt.organization_id)