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.CSTPPWRO dependencies on WIP_ENTITIES

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

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

Line 973: CURSOR c_wip_entities_mov IS

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

Line 976: FROM wip_entities we,

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

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

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

Line 993: CURSOR c_wip_entities_res IS

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

Line 997: FROM wip_entities we,

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

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

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

Line 1218: FOR c_ent_mov_rec IN c_wip_entities_mov LOOP

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

Line 1254: -- Process WIP entities with resource transactions

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

Line 1258: FOR c_ent_rec IN c_wip_entities_res LOOP

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

Line 1967: -- Populates all the wip entities for this assembly

1963:
1964: -------------------------------------------------------------------
1965: -- This Cursor will get all scrap quantity without scrap account
1966: -- in this period for a given assembly
1967: -- Populates all the wip entities for this assembly
1968: --------------------------------------------------------------------
1969:
1970: CURSOR scrap_no_account is
1971: SELECT wmt.transaction_id wip_txn_id,