APPS.WSM_WLT_VALIDATE_PVT dependencies on WIP_OPERATIONS

Line 1337: from wip_operations wo

1333: operation_sequence_id,
1334: department_id,
1335: description,
1336: nvl(quantity_in_queue,0)+nvl(quantity_waiting_to_move,0) qty_available
1337: from wip_operations wo
1338: where wo.organization_id = p_txn_org_id
1339: and wo.wip_entity_id = l_wip_entity_id
1340: and wo.operation_seq_num = p_starting_job_rec.operation_seq_num
1341: and (nvl(wo.quantity_in_queue,0) > 0 or nvl(wo.quantity_waiting_to_move,0) > 0);

Line 1353: from wip_operations wo

1349: operation_sequence_id,
1350: department_id,
1351: description,
1352: nvl(quantity_in_queue,0)+nvl(quantity_waiting_to_move,0) qty_available
1353: from wip_operations wo
1354: where wo.organization_id = p_txn_org_id
1355: and wo.wip_entity_id = l_wip_entity_id
1356: and wo.operation_seq_num = operation_seq_num
1357: and (nvl(wo.quantity_in_queue,0) > 0 or nvl(wo.quantity_waiting_to_move,0) > 0);

Line 1394: l_op_description WIP_OPERATIONS.DESCRIPTION%TYPE;

1390: l_quantity_waiting_to_move NUMBER;
1391: l_standard_operation_id NUMBER;
1392: l_operation_sequence_id NUMBER;
1393: l_department_id NUMBER;
1394: l_op_description WIP_OPERATIONS.DESCRIPTION%TYPE;
1395: l_qty_available NUMBER;
1396:
1397: -- Status variables
1398: l_return_status VARCHAR2(1);