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_PAC_ITEM_COSTS

Line 567: cst_pac_item_costs cpic

563: )
564: AND EXISTS
565: (SELECT NULL
566: FROM cst_pac_item_cost_details cpicd,
567: cst_pac_item_costs cpic
568: WHERE cpicd.cost_layer_id = cpic.cost_layer_id
569: AND cpic.cost_group_id = p_from_cost_group_id
570: AND cpic.pac_period_id = p_period_id
571: AND cpic.inventory_item_id = cicd.inventory_item_id);

Line 621: FROM cst_pac_item_costs cpic

617: AND p_range = 5)
618: )
619: AND EXISTS
620: (SELECT NULL
621: FROM cst_pac_item_costs cpic
622: WHERE cpic.cost_group_id = p_from_cost_group_id
623: AND cpic.pac_period_id = p_period_id
624: AND cpic.inventory_item_id = cic.inventory_item_id);
625:

Line 653: FROM cst_pac_item_costs cpic

649: AND p_range = 5)
650: )
651: AND EXISTS
652: (SELECT NULL
653: FROM cst_pac_item_costs cpic
654: WHERE cpic.cost_group_id = p_from_cost_group_id
655: AND cpic.pac_period_id = p_period_id
656: AND cpic.inventory_item_id = cic.inventory_item_id);
657:

Line 784: FROM cst_pac_item_costs CPIC,

780: , l_request_id
781: , 702
782: , l_program_id
783: , SYSDATE
784: FROM cst_pac_item_costs CPIC,
785: mtl_system_items MSI,
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

Line 898: FROM cst_pac_item_costs CPIC,

894: , l_request_id
895: , 702
896: , l_program_id
897: , SYSDATE
898: FROM cst_pac_item_costs CPIC,
899: cst_pac_item_cost_details CPICD,
900: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
901: WHERE CPIC.pac_period_id = p_period_id
902: AND CPIC.cost_group_id = p_from_cost_group_id

Line 1062: FROM cst_pac_item_costs CPIC,

1058: , l_request_id
1059: , 702
1060: , l_program_id
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

Line 1171: FROM cst_pac_item_costs CPIC,

1167: , l_request_id
1168: , 702
1169: , l_program_id
1170: , SYSDATE
1171: FROM cst_pac_item_costs CPIC,
1172: cst_pac_item_cost_details CPICD,
1173: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1174: WHERE CPIC.pac_period_id = p_period_id
1175: AND CPIC.cost_group_id = p_from_cost_group_id

Line 1307: FROM cst_pac_item_costs cpic

1303: AND p_range = 5)
1304: )
1305: AND EXISTS
1306: (SELECT NULL
1307: FROM cst_pac_item_costs cpic
1308: WHERE cpic.cost_group_id = p_from_cost_group_id
1309: AND cpic.pac_period_id = p_period_id
1310: AND cpic.inventory_item_id = cic.inventory_item_id);
1311:

Line 1465: FROM cst_pac_item_costs CPIC,

1461: , l_request_id
1462: , 702
1463: , l_program_id
1464: , SYSDATE
1465: FROM cst_pac_item_costs CPIC,
1466: mtl_system_items MSI,
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

Line 1580: FROM cst_pac_item_costs CPIC,

1576: , l_request_id
1577: , 702
1578: , l_program_id
1579: , SYSDATE
1580: FROM cst_pac_item_costs CPIC,
1581: cst_pac_item_cost_details CPICD,
1582: mtl_system_items MSI -- Bug 2570867 - joined with MSI to select only to_org items
1583: WHERE CPIC.pac_period_id = p_period_id
1584: AND CPIC.cost_group_id = p_from_cost_group_id