DBA Data[Home] [Help]

APPS.WMA_COMPLETION dependencies on WIP_OPERATIONS

Line 1215: from wip_operations wo

1211: lastOpSeq NUMBER;
1212:
1213: cursor getLastOpSeq (wipEntityID NUMBER, orgID NUMBER) IS
1214: select max(wo.operation_seq_num)
1215: from wip_operations wo
1216: where wo.organization_id = orgID
1217: and wo.wip_entity_id = wipEntityID;
1218: BEGIN
1219:

Line 1249: from wip_operations wo

1245: availableQty NUMBER;
1246:
1247: cursor getAvailableQty (v_wipEntityID NUMBER, v_orgID NUMBER, v_lastOpSeq NUMBER) IS
1248: select wo.quantity_waiting_to_move
1249: from wip_operations wo
1250: where wo.organization_id = v_orgID
1251: and wo.wip_entity_id = v_wipEntityID
1252: and wo.operation_seq_num = v_lastOpSeq;
1253: BEGIN

Line 1552: from wip_operations

1548: end if;
1549:
1550: select nvl(min(operation_seq_num), 1), nvl(max(operation_seq_num), 1)
1551: into l_minOpSeqNum, l_maxOpSeqNum
1552: from wip_operations
1553: where wip_entity_id = p_jobID;
1554:
1555: l_compTbl := system.wip_component_tbl_t();
1556: