[Home] [Help]
913: (select trunc(period_end_date)
914: from cst_pac_periods
915: where pac_period_id = l_closing_pac_period_id )
916: AND organization_id IN ( SELECT ccga.organization_id
917: FROM cst_cost_group_assignments ccga
918: WHERE ccga.cost_group_id = l_current_cost_group_id
919: )
920: AND rownum < 2;
921:
927: SELECT count(1)
928: FROM mtl_material_transactions mmt
929: WHERE mmt.organization_id IN
930: (select ccga.organization_id
931: from cst_cost_group_assignments ccga
932: where ccga.cost_group_id = l_current_cost_group_id)
933: AND mmt.transaction_date >=
934: (select trunc(period_start_date)
935: from cst_pac_periods
971: AND cppp.cost_group_id = l_current_cost_group_id
972: )
973: AND mmt.organization_id IN
974: (select ccga.organization_id
975: from cst_cost_group_assignments ccga
976: where ccga.cost_group_id = l_current_cost_group_id)
977: AND mmt.transaction_date >=
978: (select trunc(period_start_date)
979: from cst_pac_periods
1013: AND cppp.cost_group_id = l_current_cost_group_id
1014: )
1015: AND wt.organization_id IN
1016: (select ccga.organization_id
1017: from cst_cost_group_assignments ccga
1018: where ccga.cost_group_id = l_current_cost_group_id)
1019: AND wt.transaction_date >=
1020: (select trunc(period_start_date)
1021: from cst_pac_periods
1056: AND cppp.cost_group_id = l_current_cost_group_id
1057: )
1058: AND rt.organization_id IN
1059: (select ccga.organization_id
1060: from cst_cost_group_assignments ccga
1061: where ccga.cost_group_id = l_current_cost_group_id)
1062: AND rt.transaction_date >=
1063: (select trunc(period_start_date)
1064: from cst_pac_periods
1097: AND cppp.cost_group_id = l_current_cost_group_id
1098: )
1099: AND rae.organization_id IN
1100: (select ccga.organization_id
1101: from cst_cost_group_assignments ccga
1102: where ccga.cost_group_id = l_current_cost_group_id)
1103: AND rae.transaction_date >=
1104: (select trunc(period_start_date)
1105: from cst_pac_periods
1140: AND cppp.cost_group_id = l_current_cost_group_id
1141: )
1142: AND clat.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 clat.transaction_date >=
1147: (select trunc(period_start_date)
1148: from cst_pac_periods
1165: and ccg.cost_group_type = 2
1166: and NVL(ccg.disable_date, sysdate) >= sysdate
1167: and ccg.cost_group_id IN (
1168: SELECT distinct cost_group_id
1169: FROM cst_cost_group_assignments
1170: WHERE legal_entity = l_entity_id );
1171:
1172: /* **************************************************************************** */
1173: /* Cursor to check for pending txn in MMTT */
1178: FROM mtl_material_transactions_temp mmtt
1179: WHERE NVL(mmtt.transaction_status,0) <> 2
1180: AND mmtt.organization_id IN
1181: (select ccga.organization_id
1182: from cst_cost_group_assignments ccga
1183: where ccga.cost_group_id = l_current_cost_group_id)
1184: AND mmtt.transaction_date >=
1185: (select trunc(period_start_date)
1186: from cst_pac_periods
1199: SELECT count(1)
1200: FROM mtl_transactions_interface mti
1201: WHERE mti.organization_id IN
1202: (select ccga.organization_id
1203: from cst_cost_group_assignments ccga
1204: where ccga.cost_group_id = l_current_cost_group_id)
1205: AND mti.transaction_date >=
1206: (select trunc(period_start_date)
1207: from cst_pac_periods
1220: SELECT count(1)
1221: FROM wip_cost_txn_interface wcti
1222: WHERE wcti.organization_id IN
1223: (select ccga.organization_id
1224: from cst_cost_group_assignments ccga
1225: where ccga.cost_group_id = l_current_cost_group_id)
1226: AND wcti.transaction_date >=
1227: (select trunc(period_start_date)
1228: from cst_pac_periods
1241: SELECT count(1)
1242: FROM rcv_transactions_interface rti
1243: WHERE rti.to_organization_code IN
1244: (select mp.organization_code
1245: from cst_cost_group_assignments ccga,
1246: mtl_parameters mp
1247: where ccga.cost_group_id = l_current_cost_group_id
1248: and ccga.organization_id = mp.organization_id)
1249: AND rti.transaction_date >=
1263: SELECT count(1)
1264: FROM cst_lc_adj_interface lci
1265: WHERE lci.organization_id IN
1266: (select ccga.organization_id
1267: from cst_cost_group_assignments ccga
1268: where ccga.cost_group_id = l_current_cost_group_id)
1269: AND lci.transaction_date >=
1270: (select trunc(period_start_date)
1271: from cst_pac_periods
1287: SELECT 'Y'
1288: FROM MTL_MATERIAL_TRANSACTIONS
1289: WHERE transaction_source_type_id IN (2,12)
1290: AND organization_id IN (Select ccga.organization_id
1291: from cst_cost_group_assignments ccga,
1292: cst_cost_groups ccg
1293: where ccga.cost_group_id = ccg.cost_group_id
1294: and ccg.legal_entity = c_legal_entity_id
1295: and ccg.cost_group_type = 2
1879: SELECT min(crrl.acct_period_num)
1880: INTO l_phase3_required
1881: FROM cst_revenue_recognition_lines crrl,
1882: cst_revenue_cogs_match_lines crcml,
1883: cst_cost_group_assignments ccga,
1884: cst_cost_groups ccg
1885: WHERE crrl.ledger_id = l_ledger_id
1886: AND crrl.potentially_unmatched_flag = 'Y'
1887: AND crrl.revenue_om_line_id = crcml.revenue_om_line_id
2156: and ccg.cost_group_type = 2
2157: and NVL(ccg.disable_date, sysdate) >= sysdate
2158: and ccg.cost_group_id IN (
2159: SELECT distinct cost_group_id
2160: FROM cst_cost_group_assignments
2161: WHERE legal_entity = l_entity_id );
2162:
2163: /* **************************************************************************** */
2164: /* Cursor to check whether the period is still open to be closed */