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.CSTPPWAC dependencies on CST_PAC_LOW_LEVEL_CODES

Line 3973: FROM cst_pac_low_level_codes cpllc

3969: AND mpacd.cost_group_id = i_cost_group_id
3970: AND mpacd.pac_period_id = i_pac_period_id
3971: AND mpacd.inventory_item_id = i_item_id
3972: AND NOT EXISTS (SELECT 1
3973: FROM cst_pac_low_level_codes cpllc
3974: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
3975: AND cpllc.pac_period_id = i_pac_period_id
3976: AND cpllc.cost_group_id = i_cost_group_id);
3977: ELSE

Line 3991: FROM cst_pac_low_level_codes cpllc

3987: WHERE mpacd.pac_period_id = i_pac_period_id
3988: AND mpacd.cost_group_id = i_cost_group_id
3989: AND mpacd.inventory_item_id = i_item_id
3990: AND EXISTS (SELECT 1
3991: FROM cst_pac_low_level_codes cpllc
3992: WHERE cpllc.cost_group_id = i_cost_group_id
3993: AND cpllc.pac_period_id = i_pac_period_id
3994: AND cpllc.inventory_item_id = mpacd.inventory_item_id
3995: AND cpllc.low_level_code = i_low_level_code);

Line 4026: FROM cst_pac_low_level_codes cpllc

4022: AND mpacd.cost_group_id = i_cost_group_id
4023: AND mpacd.pac_period_id = i_pac_period_id
4024: AND mpacd.inventory_item_id = i_item_id
4025: AND EXISTS (SELECT 1
4026: FROM cst_pac_low_level_codes cpllc
4027: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4028: AND cpllc.low_level_code = i_low_level_code
4029: AND cpllc.pac_period_id = i_pac_period_id
4030: AND cpllc.cost_group_id = i_cost_group_id);

Line 4053: FROM cst_pac_low_level_codes cpllc

4049: AND mpacd.cost_group_id = i_cost_group_id
4050: AND mpacd.pac_period_id = i_pac_period_id
4051: AND mpacd.inventory_item_id = i_item_id
4052: AND EXISTS (SELECT 1
4053: FROM cst_pac_low_level_codes cpllc
4054: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4055: AND cpllc.low_level_code = i_low_level_code
4056: AND cpllc.pac_period_id = i_pac_period_id
4057: AND cpllc.cost_group_id = i_cost_group_id);

Line 4229: FROM cst_pac_low_level_codes cpllc

4225: AND cppb.cost_element_id = cpicd.cost_element_id
4226: AND cppb.level_type = cpicd.level_type
4227: AND cppb.inventory_item_id = i_item_id)
4228: AND NOT EXISTS (SELECT 1
4229: FROM cst_pac_low_level_codes cpllc
4230: WHERE cpllc.pac_period_id = i_pac_period_id
4231: AND cpllc.cost_group_id = i_cost_group_id
4232: AND cpllc.inventory_item_id = i_item_id);
4233:

Line 4305: FROM cst_pac_low_level_codes cpllc

4301: WHERE cppb.pac_period_id = i_pac_period_id
4302: AND cppb.cost_group_id = i_cost_group_id
4303: AND cppb.cost_layer_id = cpic.cost_layer_id)
4304: AND NOT EXISTS (SELECT 1
4305: FROM cst_pac_low_level_codes cpllc
4306: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
4307: AND cpllc.pac_period_id = i_pac_period_id
4308: AND cpllc.cost_group_id = i_cost_group_id)
4309: AND EXISTS

Line 4382: FROM cst_pac_low_level_codes cpllc

4378: AND cppb.cost_element_id = cpicd.cost_element_id
4379: AND cppb.level_type = cpicd.level_type
4380: AND cppb.inventory_item_id = i_item_id)
4381: AND EXISTS (SELECT 1
4382: FROM cst_pac_low_level_codes cpllc
4383: WHERE cpllc.low_level_code = i_low_level_code
4384: AND cpllc.pac_period_id = i_pac_period_id
4385: AND cpllc.cost_group_id = i_cost_group_id
4386: AND cpllc.inventory_item_id = i_item_id);

Line 4459: FROM cst_pac_low_level_codes cpllc

4455: WHERE cppb.pac_period_id = i_pac_period_id
4456: AND cppb.cost_group_id = i_cost_group_id
4457: AND cppb.cost_layer_id = cpic.cost_layer_id)
4458: AND EXISTS (SELECT 1
4459: FROM cst_pac_low_level_codes cpllc
4460: WHERE cpllc.low_level_code = i_low_level_code
4461: AND cpllc.inventory_item_id = cpic.inventory_item_id
4462: AND cpllc.pac_period_id = i_pac_period_id
4463: AND cpllc.cost_group_id = i_cost_group_id)

Line 4580: FROM cst_pac_low_level_codes cpllc

4576: AND mpacd1.cost_group_id = i_cost_group_id)
4577: AND mpacd.cost_group_id = i_cost_group_id
4578: AND mpacd.pac_period_id = i_pac_period_id
4579: AND NOT EXISTS (SELECT 1
4580: FROM cst_pac_low_level_codes cpllc
4581: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4582: AND cpllc.pac_period_id = i_pac_period_id
4583: AND cpllc.cost_group_id = i_cost_group_id);
4584: ELSE

Line 4597: FROM cst_pac_low_level_codes cpllc

4593: FROM mtl_pac_actual_cost_details mpacd
4594: WHERE mpacd.pac_period_id = i_pac_period_id
4595: AND mpacd.cost_group_id = i_cost_group_id
4596: AND EXISTS (SELECT 1
4597: FROM cst_pac_low_level_codes cpllc
4598: WHERE cpllc.cost_group_id = i_cost_group_id
4599: AND cpllc.pac_period_id = i_pac_period_id
4600: AND cpllc.inventory_item_id = mpacd.inventory_item_id
4601: AND cpllc.low_level_code = i_low_level_code);

Line 4631: FROM cst_pac_low_level_codes cpllc

4627: AND mpacd1.cost_group_id = i_cost_group_id)
4628: AND mpacd.cost_group_id = i_cost_group_id
4629: AND mpacd.pac_period_id = i_pac_period_id
4630: AND EXISTS (SELECT 1
4631: FROM cst_pac_low_level_codes cpllc
4632: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4633: AND cpllc.low_level_code = i_low_level_code
4634: AND cpllc.pac_period_id = i_pac_period_id
4635: AND cpllc.cost_group_id = i_cost_group_id);

Line 4657: FROM cst_pac_low_level_codes cpllc

4653: AND mpacd1.cost_group_id = i_cost_group_id)
4654: AND mpacd.cost_group_id = i_cost_group_id
4655: AND mpacd.pac_period_id = i_pac_period_id
4656: AND EXISTS (SELECT 1
4657: FROM cst_pac_low_level_codes cpllc
4658: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4659: AND cpllc.low_level_code = i_low_level_code
4660: AND cpllc.pac_period_id = i_pac_period_id
4661: AND cpllc.cost_group_id = i_cost_group_id);

Line 4831: FROM cst_pac_low_level_codes cpllc,

4827: AND cppb.cost_layer_id = cpicd.cost_layer_id
4828: AND cppb.cost_element_id = cpicd.cost_element_id
4829: AND cppb.level_type = cpicd.level_type)
4830: AND NOT EXISTS (SELECT 1
4831: FROM cst_pac_low_level_codes cpllc,
4832: cst_pac_item_costs cpic1
4833: WHERE cpllc.inventory_item_id = cpic1.inventory_item_id
4834: AND cpic1.cost_layer_id = cpicd.cost_layer_id
4835: AND cpllc.pac_period_id = i_pac_period_id

Line 4908: FROM cst_pac_low_level_codes cpllc

4904: WHERE cppb.pac_period_id = i_pac_period_id
4905: AND cppb.cost_group_id = i_cost_group_id
4906: AND cppb.cost_layer_id = cpic.cost_layer_id)
4907: AND NOT EXISTS (SELECT 1
4908: FROM cst_pac_low_level_codes cpllc
4909: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
4910: AND cpllc.pac_period_id = i_pac_period_id
4911: AND cpllc.cost_group_id = i_cost_group_id)
4912: AND EXISTS

Line 4983: FROM cst_pac_low_level_codes cpllc,

4979: AND cppb.cost_layer_id = cpicd.cost_layer_id
4980: AND cppb.cost_element_id = cpicd.cost_element_id
4981: AND cppb.level_type = cpicd.level_type)
4982: AND EXISTS (SELECT 1
4983: FROM cst_pac_low_level_codes cpllc,
4984: cst_pac_item_costs cpic1
4985: WHERE cpllc.low_level_code = i_low_level_code
4986: AND cpllc.pac_period_id = i_pac_period_id
4987: AND cpllc.cost_group_id = i_cost_group_id

Line 5061: FROM cst_pac_low_level_codes cpllc

5057: WHERE cppb.pac_period_id = i_pac_period_id
5058: AND cppb.cost_group_id = i_cost_group_id
5059: AND cppb.cost_layer_id = cpic.cost_layer_id)
5060: AND EXISTS (SELECT 1
5061: FROM cst_pac_low_level_codes cpllc
5062: WHERE cpllc.low_level_code = i_low_level_code
5063: AND cpllc.inventory_item_id = cpic.inventory_item_id
5064: AND cpllc.pac_period_id = i_pac_period_id
5065: AND cpllc.cost_group_id = i_cost_group_id)

Line 5375: FROM cst_pac_low_level_codes cpllc

5371: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5372: AND cppb.cost_element_id = cpicd1.cost_element_id
5373: AND cppb.level_type = cpicd1.level_type)
5374: AND NOT EXISTS (SELECT 1
5375: FROM cst_pac_low_level_codes cpllc
5376: WHERE cpllc.inventory_item_id = cppb.inventory_item_id
5377: AND cpllc.pac_period_id = i_pac_period_id
5378: AND cpllc.cost_group_id = i_cost_group_id);
5379: ELSIF (i_low_level_code <> -1) THEN

Line 5439: FROM cst_pac_low_level_codes cpllc

5435: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5436: AND cppb.cost_element_id = cpicd1.cost_element_id
5437: AND cppb.level_type = cpicd1.level_type)
5438: AND EXISTS (SELECT 1
5439: FROM cst_pac_low_level_codes cpllc
5440: WHERE cpllc.inventory_item_id = cppb.inventory_item_id
5441: AND cpllc.low_level_code = i_low_level_code
5442: AND cpllc.pac_period_id = i_pac_period_id
5443: AND cpllc.cost_group_id = i_cost_group_id);