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.WMA_COMPLETION dependencies on WIP_OPERATIONS

Line 1206: from wip_operations wo

1202: lastOpSeq NUMBER;
1203:
1204: cursor getLastOpSeq (wipEntityID NUMBER, orgID NUMBER) IS
1205: select max(wo.operation_seq_num)
1206: from wip_operations wo
1207: where wo.organization_id = orgID
1208: and wo.wip_entity_id = wipEntityID;
1209: BEGIN
1210:

Line 1240: from wip_operations wo

1236: availableQty NUMBER;
1237:
1238: cursor getAvailableQty (v_wipEntityID NUMBER, v_orgID NUMBER, v_lastOpSeq NUMBER) IS
1239: select wo.quantity_waiting_to_move
1240: from wip_operations wo
1241: where wo.organization_id = v_orgID
1242: and wo.wip_entity_id = v_wipEntityID
1243: and wo.operation_seq_num = v_lastOpSeq;
1244: BEGIN

Line 1543: from wip_operations

1539: end if;
1540:
1541: select nvl(min(operation_seq_num), 1), nvl(max(operation_seq_num), 1)
1542: into l_minOpSeqNum, l_maxOpSeqNum
1543: from wip_operations
1544: where wip_entity_id = p_jobID;
1545:
1546: l_compTbl := system.wip_component_tbl_t();
1547: