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.CSTPPCIC dependencies on CST_COST_TYPES

Line 251: from cst_cost_types cct

247:
248:
249: select 1
250: into l_valid
251: from cst_cost_types cct
252: where cost_type_id = p_from_cost_type_id
253: and cost_type_id in
254: (select distinct clct.cost_type_id
255: from cst_le_cost_types clct

Line 349: from cst_cost_types

345: into l_valid
346: from dual
347: where p_to_cost_type_id in
348: (select distinct cost_type_id
349: from cst_cost_types
350: where organization_id = p_to_org_id
351: and cost_type_id not in (1,2,3)
352: and nvl(allow_updates_flag,1) = 1
353: and nvl(disable_date, sysdate+1) > sysdate

Line 790: FROM cst_cost_types cct, cst_item_costs cic

786: (SELECT inventory_item_id, based_on_rollup_flag
787: FROM cst_item_costs_interface
788: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
789: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag
790: FROM cst_cost_types cct, cst_item_costs cic
791: WHERE cic.organization_id = p_to_org_id
792: AND cct.cost_type_id = p_to_cost_type_id
793: AND cic.cost_type_id = cct.default_cost_type_id) dBORF -- based_on_rollup_flag from default cost type
794: WHERE CPIC.pac_period_id = p_period_id

Line 1065: FROM cst_cost_types cct, cst_item_costs cic

1061: , SYSDATE
1062: FROM cst_pac_item_costs CPIC,
1063: mtl_system_items MSI,
1064: (SELECT cic.inventory_item_id, based_on_rollup_flag
1065: FROM cst_cost_types cct, cst_item_costs cic
1066: WHERE cic.organization_id = p_to_org_id
1067: AND cct.cost_type_id = p_to_cost_type_id
1068: AND cic.cost_type_id = cct.default_cost_type_id) dBORF -- based_on_rollup_flag from default cost type
1069:

Line 1471: FROM cst_cost_types cct, cst_item_costs cic

1467: (SELECT inventory_item_id, based_on_rollup_flag
1468: FROM cst_item_costs_interface
1469: WHERE group_id = l_grp_id) BORF, -- based_on_rollup_flag backed up from destination cost type
1470: (SELECT cic.inventory_item_id, cic.based_on_rollup_flag
1471: FROM cst_cost_types cct, cst_item_costs cic
1472: WHERE cic.organization_id = p_to_org_id
1473: AND cct.cost_type_id = p_to_cost_type_id
1474: AND cic.cost_type_id = cct.default_cost_type_id) dBORF -- based_on_rollup_flag from default cost type
1475: WHERE CPIC.pac_period_id = p_period_id