APPS.CSTPPWRO dependencies on WIP_ENTITIES

Line 970: -- Cursor to get all wip_entities in the Cost Group that has move transactions

966: l_applied_value NUMBER;
967: l_actual_cost NUMBER;
968: l_del_qty NUMBER;
969:
970: -- Cursor to get all wip_entities in the Cost Group that has move transactions
971:
972: CURSOR c_wip_entities_mov IS
973: SELECT we.wip_entity_id entity_id,
974: we.entity_type entity_type

Line 972: CURSOR c_wip_entities_mov IS

968: l_del_qty NUMBER;
969:
970: -- Cursor to get all wip_entities in the Cost Group that has move transactions
971:
972: CURSOR c_wip_entities_mov IS
973: SELECT we.wip_entity_id entity_id,
974: we.entity_type entity_type
975: FROM wip_entities we,
976: cst_cost_group_assignments ccga

Line 975: FROM wip_entities we,

971:
972: CURSOR c_wip_entities_mov IS
973: SELECT we.wip_entity_id entity_id,
974: we.entity_type entity_type
975: FROM wip_entities we,
976: cst_cost_group_assignments ccga
977: WHERE ccga.cost_group_id = p_cost_group_id
978: AND we.organization_id = ccga.organization_id
979: AND we.entity_type <> 4 -- NOT CFM

Line 990: -- Cursor to get all wip_entities in the Cost Group that has resource transactions

986: TRUNC(p_start_date) AND
987: (TRUNC(p_end_date) + 0.99999)
988: );
989:
990: -- Cursor to get all wip_entities in the Cost Group that has resource transactions
991:
992: CURSOR c_wip_entities_res IS
993: SELECT we.wip_entity_id entity_id,
994: we.entity_type entity_type,

Line 992: CURSOR c_wip_entities_res IS

988: );
989:
990: -- Cursor to get all wip_entities in the Cost Group that has resource transactions
991:
992: CURSOR c_wip_entities_res IS
993: SELECT we.wip_entity_id entity_id,
994: we.entity_type entity_type,
995: we.organization_id org_id
996: FROM wip_entities we,

Line 996: FROM wip_entities we,

992: CURSOR c_wip_entities_res IS
993: SELECT we.wip_entity_id entity_id,
994: we.entity_type entity_type,
995: we.organization_id org_id
996: FROM wip_entities we,
997: cst_cost_group_assignments ccga
998: WHERE ccga.cost_group_id = p_cost_group_id
999: AND we.organization_id = ccga.organization_id
1000: AND EXISTS

Line 1213: -- Process Non-CFM WIP entities with move transactions

1209:
1210: l_stmt_num := 7;
1211:
1212: ----------------------------------------------------------------------
1213: -- Process Non-CFM WIP entities with move transactions
1214: ----------------------------------------------------------------------
1215: l_stmt_num := 10;
1216:
1217: FOR c_ent_mov_rec IN c_wip_entities_mov LOOP

Line 1217: FOR c_ent_mov_rec IN c_wip_entities_mov LOOP

1213: -- Process Non-CFM WIP entities with move transactions
1214: ----------------------------------------------------------------------
1215: l_stmt_num := 10;
1216:
1217: FOR c_ent_mov_rec IN c_wip_entities_mov LOOP
1218: ------------------------------------------------------
1219: -- Update op qty snapshot for this entity based on
1220: -- this period's move txns.
1221: ------------------------------------------------------

Line 1253: -- Process WIP entities with resource transactions

1249:
1250: END LOOP;
1251:
1252: ----------------------------------------------------------------------
1253: -- Process WIP entities with resource transactions
1254: ----------------------------------------------------------------------
1255: l_stmt_num := 20;
1256:
1257: FOR c_ent_rec IN c_wip_entities_res LOOP

Line 1257: FOR c_ent_rec IN c_wip_entities_res LOOP

1253: -- Process WIP entities with resource transactions
1254: ----------------------------------------------------------------------
1255: l_stmt_num := 20;
1256:
1257: FOR c_ent_rec IN c_wip_entities_res LOOP
1258:
1259: --------------------------------------------------------------
1260: -- Get Resource/OSP (and RBO) Transactions
1261: --------------------------------------------------------------