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.CSTPPPSC dependencies on CST_COST_GROUP_ASSIGNMENTS

Line 880: FROM cst_cost_group_assignments ccga

876: (select trunc(period_end_date)
877: from cst_pac_periods
878: where pac_period_id = l_closing_pac_period_id )
879: AND organization_id IN ( SELECT ccga.organization_id
880: FROM cst_cost_group_assignments ccga
881: WHERE ccga.cost_group_id = l_current_cost_group_id
882: )
883: AND rownum < 2;
884:

Line 916: from cst_cost_group_assignments ccga

912: AND cppp.cost_group_id = l_current_cost_group_id
913: )
914: AND mmt.organization_id IN
915: (select ccga.organization_id
916: from cst_cost_group_assignments ccga
917: where ccga.cost_group_id = l_current_cost_group_id)
918: AND mmt.transaction_date >=
919: (select trunc(period_start_date)
920: from cst_pac_periods

Line 958: from cst_cost_group_assignments ccga

954: AND cppp.cost_group_id = l_current_cost_group_id
955: )
956: AND wt.organization_id IN
957: (select ccga.organization_id
958: from cst_cost_group_assignments ccga
959: where ccga.cost_group_id = l_current_cost_group_id)
960: AND wt.transaction_date >=
961: (select trunc(period_start_date)
962: from cst_pac_periods

Line 1001: from cst_cost_group_assignments ccga

997: AND cppp.cost_group_id = l_current_cost_group_id
998: )
999: AND rt.organization_id IN
1000: (select ccga.organization_id
1001: from cst_cost_group_assignments ccga
1002: where ccga.cost_group_id = l_current_cost_group_id)
1003: AND rt.transaction_date >=
1004: (select trunc(period_start_date)
1005: from cst_pac_periods

Line 1042: from cst_cost_group_assignments ccga

1038: AND cppp.cost_group_id = l_current_cost_group_id
1039: )
1040: AND rae.organization_id IN
1041: (select ccga.organization_id
1042: from cst_cost_group_assignments ccga
1043: where ccga.cost_group_id = l_current_cost_group_id)
1044: AND rae.transaction_date >=
1045: (select trunc(period_start_date)
1046: from cst_pac_periods

Line 1085: from cst_cost_group_assignments ccga

1081: AND cppp.cost_group_id = l_current_cost_group_id
1082: )
1083: AND clat.organization_id IN
1084: (select ccga.organization_id
1085: from cst_cost_group_assignments ccga
1086: where ccga.cost_group_id = l_current_cost_group_id)
1087: AND clat.transaction_date >=
1088: (select trunc(period_start_date)
1089: from cst_pac_periods

Line 1110: FROM cst_cost_group_assignments

1106: and ccg.cost_group_type = 2
1107: and NVL(ccg.disable_date, sysdate) >= sysdate
1108: and ccg.cost_group_id IN (
1109: SELECT distinct cost_group_id
1110: FROM cst_cost_group_assignments
1111: WHERE legal_entity = l_entity_id );
1112:
1113: /* **************************************************************************** */
1114: /* Cursor to check for pending txn in MMTT */

Line 1123: from cst_cost_group_assignments ccga

1119: FROM mtl_material_transactions_temp mmtt
1120: WHERE NVL(mmtt.transaction_status,0) <> 2
1121: AND mmtt.organization_id IN
1122: (select ccga.organization_id
1123: from cst_cost_group_assignments ccga
1124: where ccga.cost_group_id = l_current_cost_group_id)
1125: AND mmtt.transaction_date >=
1126: (select trunc(period_start_date)
1127: from cst_pac_periods

Line 1144: from cst_cost_group_assignments ccga

1140: SELECT count(1)
1141: FROM mtl_transactions_interface mti
1142: WHERE mti.organization_id IN
1143: (select ccga.organization_id
1144: from cst_cost_group_assignments ccga
1145: where ccga.cost_group_id = l_current_cost_group_id)
1146: AND mti.transaction_date >=
1147: (select trunc(period_start_date)
1148: from cst_pac_periods

Line 1165: from cst_cost_group_assignments ccga

1161: SELECT count(1)
1162: FROM wip_cost_txn_interface wcti
1163: WHERE wcti.organization_id IN
1164: (select ccga.organization_id
1165: from cst_cost_group_assignments ccga
1166: where ccga.cost_group_id = l_current_cost_group_id)
1167: AND wcti.transaction_date >=
1168: (select trunc(period_start_date)
1169: from cst_pac_periods

Line 1186: from cst_cost_group_assignments ccga,

1182: SELECT count(1)
1183: FROM rcv_transactions_interface rti
1184: WHERE rti.to_organization_code IN
1185: (select mp.organization_code
1186: from cst_cost_group_assignments ccga,
1187: mtl_parameters mp
1188: where ccga.cost_group_id = l_current_cost_group_id
1189: and ccga.organization_id = mp.organization_id)
1190: AND rti.transaction_date >=

Line 1208: from cst_cost_group_assignments ccga

1204: SELECT count(1)
1205: FROM cst_lc_adj_interface lci
1206: WHERE lci.organization_id IN
1207: (select ccga.organization_id
1208: from cst_cost_group_assignments ccga
1209: where ccga.cost_group_id = l_current_cost_group_id)
1210: AND lci.transaction_date >=
1211: (select trunc(period_start_date)
1212: from cst_pac_periods

Line 1684: cst_cost_group_assignments ccga,

1680: SELECT min(crrl.acct_period_num)
1681: INTO l_phase3_required
1682: FROM cst_revenue_recognition_lines crrl,
1683: cst_revenue_cogs_match_lines crcml,
1684: cst_cost_group_assignments ccga,
1685: cst_cost_groups ccg
1686: WHERE crrl.ledger_id = l_ledger_id
1687: AND crrl.potentially_unmatched_flag = 'Y'
1688: AND crrl.revenue_om_line_id = crcml.revenue_om_line_id

Line 1957: FROM cst_cost_group_assignments

1953: and ccg.cost_group_type = 2
1954: and NVL(ccg.disable_date, sysdate) >= sysdate
1955: and ccg.cost_group_id IN (
1956: SELECT distinct cost_group_id
1957: FROM cst_cost_group_assignments
1958: WHERE legal_entity = l_entity_id );
1959:
1960: /* **************************************************************************** */
1961: /* Cursor to check whether the period is still open to be closed */