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 3942: FROM cst_pac_low_level_codes cpllc

3938: AND mpacd.cost_group_id = i_cost_group_id
3939: AND mpacd.pac_period_id = i_pac_period_id
3940: AND mpacd.inventory_item_id = i_item_id
3941: AND NOT EXISTS (SELECT 1
3942: FROM cst_pac_low_level_codes cpllc
3943: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
3944: AND cpllc.pac_period_id = i_pac_period_id
3945: AND cpllc.cost_group_id = i_cost_group_id);
3946: ELSE

Line 3960: FROM cst_pac_low_level_codes cpllc

3956: WHERE mpacd.pac_period_id = i_pac_period_id
3957: AND mpacd.cost_group_id = i_cost_group_id
3958: AND mpacd.inventory_item_id = i_item_id
3959: AND EXISTS (SELECT 1
3960: FROM cst_pac_low_level_codes cpllc
3961: WHERE cpllc.cost_group_id = i_cost_group_id
3962: AND cpllc.pac_period_id = i_pac_period_id
3963: AND cpllc.inventory_item_id = mpacd.inventory_item_id
3964: AND cpllc.low_level_code = i_low_level_code);

Line 3995: FROM cst_pac_low_level_codes cpllc

3991: AND mpacd.cost_group_id = i_cost_group_id
3992: AND mpacd.pac_period_id = i_pac_period_id
3993: AND mpacd.inventory_item_id = i_item_id
3994: AND EXISTS (SELECT 1
3995: FROM cst_pac_low_level_codes cpllc
3996: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
3997: AND cpllc.low_level_code = i_low_level_code
3998: AND cpllc.pac_period_id = i_pac_period_id
3999: AND cpllc.cost_group_id = i_cost_group_id);

Line 4022: FROM cst_pac_low_level_codes cpllc

4018: AND mpacd.cost_group_id = i_cost_group_id
4019: AND mpacd.pac_period_id = i_pac_period_id
4020: AND mpacd.inventory_item_id = i_item_id
4021: AND EXISTS (SELECT 1
4022: FROM cst_pac_low_level_codes cpllc
4023: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4024: AND cpllc.low_level_code = i_low_level_code
4025: AND cpllc.pac_period_id = i_pac_period_id
4026: AND cpllc.cost_group_id = i_cost_group_id);

Line 4198: FROM cst_pac_low_level_codes cpllc

4194: AND cppb.cost_element_id = cpicd.cost_element_id
4195: AND cppb.level_type = cpicd.level_type
4196: AND cppb.inventory_item_id = i_item_id)
4197: AND NOT EXISTS (SELECT 1
4198: FROM cst_pac_low_level_codes cpllc
4199: WHERE cpllc.pac_period_id = i_pac_period_id
4200: AND cpllc.cost_group_id = i_cost_group_id
4201: AND cpllc.inventory_item_id = i_item_id);
4202:

Line 4274: FROM cst_pac_low_level_codes cpllc

4270: WHERE cppb.pac_period_id = i_pac_period_id
4271: AND cppb.cost_group_id = i_cost_group_id
4272: AND cppb.cost_layer_id = cpic.cost_layer_id)
4273: AND NOT EXISTS (SELECT 1
4274: FROM cst_pac_low_level_codes cpllc
4275: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
4276: AND cpllc.pac_period_id = i_pac_period_id
4277: AND cpllc.cost_group_id = i_cost_group_id)
4278: AND EXISTS

Line 4351: FROM cst_pac_low_level_codes cpllc

4347: AND cppb.cost_element_id = cpicd.cost_element_id
4348: AND cppb.level_type = cpicd.level_type
4349: AND cppb.inventory_item_id = i_item_id)
4350: AND EXISTS (SELECT 1
4351: FROM cst_pac_low_level_codes cpllc
4352: WHERE cpllc.low_level_code = i_low_level_code
4353: AND cpllc.pac_period_id = i_pac_period_id
4354: AND cpllc.cost_group_id = i_cost_group_id
4355: AND cpllc.inventory_item_id = i_item_id);

Line 4428: FROM cst_pac_low_level_codes cpllc

4424: WHERE cppb.pac_period_id = i_pac_period_id
4425: AND cppb.cost_group_id = i_cost_group_id
4426: AND cppb.cost_layer_id = cpic.cost_layer_id)
4427: AND EXISTS (SELECT 1
4428: FROM cst_pac_low_level_codes cpllc
4429: WHERE cpllc.low_level_code = i_low_level_code
4430: AND cpllc.inventory_item_id = cpic.inventory_item_id
4431: AND cpllc.pac_period_id = i_pac_period_id
4432: AND cpllc.cost_group_id = i_cost_group_id)

Line 4549: FROM cst_pac_low_level_codes cpllc

4545: AND mpacd1.cost_group_id = i_cost_group_id)
4546: AND mpacd.cost_group_id = i_cost_group_id
4547: AND mpacd.pac_period_id = i_pac_period_id
4548: AND NOT EXISTS (SELECT 1
4549: FROM cst_pac_low_level_codes cpllc
4550: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4551: AND cpllc.pac_period_id = i_pac_period_id
4552: AND cpllc.cost_group_id = i_cost_group_id);
4553: ELSE

Line 4566: FROM cst_pac_low_level_codes cpllc

4562: FROM mtl_pac_actual_cost_details mpacd
4563: WHERE mpacd.pac_period_id = i_pac_period_id
4564: AND mpacd.cost_group_id = i_cost_group_id
4565: AND EXISTS (SELECT 1
4566: FROM cst_pac_low_level_codes cpllc
4567: WHERE cpllc.cost_group_id = i_cost_group_id
4568: AND cpllc.pac_period_id = i_pac_period_id
4569: AND cpllc.inventory_item_id = mpacd.inventory_item_id
4570: AND cpllc.low_level_code = i_low_level_code);

Line 4600: FROM cst_pac_low_level_codes cpllc

4596: AND mpacd1.cost_group_id = i_cost_group_id)
4597: AND mpacd.cost_group_id = i_cost_group_id
4598: AND mpacd.pac_period_id = i_pac_period_id
4599: AND EXISTS (SELECT 1
4600: FROM cst_pac_low_level_codes cpllc
4601: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4602: AND cpllc.low_level_code = i_low_level_code
4603: AND cpllc.pac_period_id = i_pac_period_id
4604: AND cpllc.cost_group_id = i_cost_group_id);

Line 4626: FROM cst_pac_low_level_codes cpllc

4622: AND mpacd1.cost_group_id = i_cost_group_id)
4623: AND mpacd.cost_group_id = i_cost_group_id
4624: AND mpacd.pac_period_id = i_pac_period_id
4625: AND EXISTS (SELECT 1
4626: FROM cst_pac_low_level_codes cpllc
4627: WHERE cpllc.inventory_item_id = mpacd.inventory_item_id
4628: AND cpllc.low_level_code = i_low_level_code
4629: AND cpllc.pac_period_id = i_pac_period_id
4630: AND cpllc.cost_group_id = i_cost_group_id);

Line 4800: FROM cst_pac_low_level_codes cpllc,

4796: AND cppb.cost_layer_id = cpicd.cost_layer_id
4797: AND cppb.cost_element_id = cpicd.cost_element_id
4798: AND cppb.level_type = cpicd.level_type)
4799: AND NOT EXISTS (SELECT 1
4800: FROM cst_pac_low_level_codes cpllc,
4801: cst_pac_item_costs cpic1
4802: WHERE cpllc.inventory_item_id = cpic1.inventory_item_id
4803: AND cpic1.cost_layer_id = cpicd.cost_layer_id
4804: AND cpllc.pac_period_id = i_pac_period_id

Line 4877: FROM cst_pac_low_level_codes cpllc

4873: WHERE cppb.pac_period_id = i_pac_period_id
4874: AND cppb.cost_group_id = i_cost_group_id
4875: AND cppb.cost_layer_id = cpic.cost_layer_id)
4876: AND NOT EXISTS (SELECT 1
4877: FROM cst_pac_low_level_codes cpllc
4878: WHERE cpllc.inventory_item_id = cpic.inventory_item_id
4879: AND cpllc.pac_period_id = i_pac_period_id
4880: AND cpllc.cost_group_id = i_cost_group_id)
4881: AND EXISTS

Line 4952: FROM cst_pac_low_level_codes cpllc,

4948: AND cppb.cost_layer_id = cpicd.cost_layer_id
4949: AND cppb.cost_element_id = cpicd.cost_element_id
4950: AND cppb.level_type = cpicd.level_type)
4951: AND EXISTS (SELECT 1
4952: FROM cst_pac_low_level_codes cpllc,
4953: cst_pac_item_costs cpic1
4954: WHERE cpllc.low_level_code = i_low_level_code
4955: AND cpllc.pac_period_id = i_pac_period_id
4956: AND cpllc.cost_group_id = i_cost_group_id

Line 5030: FROM cst_pac_low_level_codes cpllc

5026: WHERE cppb.pac_period_id = i_pac_period_id
5027: AND cppb.cost_group_id = i_cost_group_id
5028: AND cppb.cost_layer_id = cpic.cost_layer_id)
5029: AND EXISTS (SELECT 1
5030: FROM cst_pac_low_level_codes cpllc
5031: WHERE cpllc.low_level_code = i_low_level_code
5032: AND cpllc.inventory_item_id = cpic.inventory_item_id
5033: AND cpllc.pac_period_id = i_pac_period_id
5034: AND cpllc.cost_group_id = i_cost_group_id)

Line 5338: FROM cst_pac_low_level_codes cpllc

5334: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5335: AND cppb.cost_element_id = cpicd1.cost_element_id
5336: AND cppb.level_type = cpicd1.level_type)
5337: AND NOT EXISTS (SELECT 1
5338: FROM cst_pac_low_level_codes cpllc
5339: WHERE cpllc.inventory_item_id = cppb.inventory_item_id
5340: AND cpllc.pac_period_id = i_pac_period_id
5341: AND cpllc.cost_group_id = i_cost_group_id);
5342: ELSIF (i_low_level_code <> -1) THEN

Line 5398: FROM cst_pac_low_level_codes cpllc

5394: WHERE cppb.cost_layer_id = cpicd1.cost_layer_id
5395: AND cppb.cost_element_id = cpicd1.cost_element_id
5396: AND cppb.level_type = cpicd1.level_type)
5397: AND EXISTS (SELECT 1
5398: FROM cst_pac_low_level_codes cpllc
5399: WHERE cpllc.inventory_item_id = cppb.inventory_item_id
5400: AND cpllc.low_level_code = i_low_level_code
5401: AND cpllc.pac_period_id = i_pac_period_id
5402: AND cpllc.cost_group_id = i_cost_group_id);