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.CSD_HV_WIP_JOB_PVT dependencies on CSD_WIP_TRANSACTION_DETAILS

Line 1491: INSERT INTO csd_wip_transaction_details

1487: BEGIN
1488: IF p_repair_line_id IS NOT NULL
1489: THEN
1490:
1491: INSERT INTO csd_wip_transaction_details
1492: (wip_transaction_detail_id,inventory_item_id,
1493: wip_entity_id,operation_seq_num,
1494: object_version_number,
1495: last_update_login,created_by,

Line 1498: SELECT csd_wip_transaction_details_s1.nextval,t.*

1494: object_version_number,
1495: last_update_login,created_by,
1496: creation_date,last_updated_by,
1497: last_update_date)
1498: SELECT csd_wip_transaction_details_s1.nextval,t.*
1499: FROM (
1500: SELECT
1501: wro.inventory_item_id,
1502: wro.wip_entity_id,

Line 1514: FROM csd_wip_transaction_details cwt

1510: FROM csd_repair_job_xref crj,wip_requirement_operations wro
1511: WHERE crj.wip_entity_id = wro.wip_entity_id
1512: AND crj.repair_line_id = p_repair_line_id
1513: AND NOT EXISTS (SELECT 'exists'
1514: FROM csd_wip_transaction_details cwt
1515: WHERE cwt.wip_entity_id = wro.wip_entity_id
1516: AND cwt.operation_seq_num = wro.operation_seq_num
1517: AND cwt.inventory_item_id = wro.inventory_item_id
1518: )

Line 1526: INSERT INTO csd_wip_transaction_details

1522:
1523: ELSIF p_wip_entity_id IS NOT NULL
1524: THEN
1525: -- regular issue.
1526: INSERT INTO csd_wip_transaction_details
1527: (wip_transaction_detail_id,inventory_item_id,
1528: wip_entity_id,operation_seq_num,
1529: object_version_number,
1530: last_update_login,created_by,

Line 1533: SELECT csd_wip_transaction_details_s1.nextval,t.*

1529: object_version_number,
1530: last_update_login,created_by,
1531: creation_date,last_updated_by,
1532: last_update_date)
1533: SELECT csd_wip_transaction_details_s1.nextval,t.*
1534: FROM (
1535: SELECT wro.inventory_item_id,
1536: wro.wip_entity_id,
1537: wro.operation_seq_num,

Line 1547: FROM csd_wip_transaction_details cwt

1543: sysdate last_update_date
1544: FROM wip_requirement_operations wro
1545: WHERE wro.wip_entity_id = p_wip_entity_id
1546: AND NOT EXISTS (SELECT 'exists'
1547: FROM csd_wip_transaction_details cwt
1548: WHERE cwt.wip_entity_id = wro.wip_entity_id
1549: AND cwt.operation_seq_num = wro.operation_seq_num
1550: AND cwt.inventory_item_id = wro.inventory_item_id
1551: )

Line 1556: INSERT INTO csd_wip_transaction_details

1552: ) t;
1553:
1554: ELSE
1555:
1556: INSERT INTO csd_wip_transaction_details
1557: (wip_transaction_detail_id,inventory_item_id,
1558: wip_entity_id,operation_seq_num,
1559: object_version_number,
1560: last_update_login,created_by,

Line 1563: SELECT csd_wip_transaction_details_s1.nextval,t.*

1559: object_version_number,
1560: last_update_login,created_by,
1561: creation_date,last_updated_by,
1562: last_update_date)
1563: SELECT csd_wip_transaction_details_s1.nextval,t.*
1564: FROM (
1565: SELECT wro.inventory_item_id,
1566: wro.wip_entity_id,
1567: wro.operation_seq_num,

Line 1577: FROM csd_wip_transaction_details cwt

1573: sysdate last_update_date
1574: FROM wip_requirement_operations wro,csd_repair_job_xref crj
1575: WHERE crj.wip_entity_id = wro.wip_entity_id
1576: AND NOT EXISTS (SELECT 'exists'
1577: FROM csd_wip_transaction_details cwt
1578: WHERE cwt.wip_entity_id = wro.wip_entity_id
1579: AND cwt.operation_seq_num = wro.operation_seq_num
1580: AND cwt.inventory_item_id = wro.inventory_item_id
1581: )

Line 3432: ---- Update CSD_WIP_TRANSACTION_DETAILS rows to have null values

3428:
3429: END IF;
3430:
3431:
3432: ---- Update CSD_WIP_TRANSACTION_DETAILS rows to have null values
3433:
3434: If p_mtl_txn_dtls_tbl(mtl_ctr).WIP_TRANSACTION_DETAIL_ID is not null then
3435:
3436: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4429: ---- Update CSD_WIP_TRANSACTION_DETAILS rows to have null values

4425:
4426: END IF;
4427:
4428:
4429: ---- Update CSD_WIP_TRANSACTION_DETAILS rows to have null values
4430:
4431: If p_res_txn_dtls_tbl(res_ctr).WIP_TRANSACTION_DETAIL_ID is not null then
4432:
4433: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5935: -- primary key for CSD_WIP_TRANSACTION_DETAILS table

5931: l_created_by NUMBER;
5932: l_last_updated_by NUMBER;
5933: l_last_update_login NUMBER;
5934:
5935: -- primary key for CSD_WIP_TRANSACTION_DETAILS table
5936: l_wip_transaction_detail_id NUMBER;
5937:
5938: BEGIN
5939:

Line 8061: CSD_WIP_TRANSACTION_DETAILS CWTD,

8057: CSD_REPAIR_JOB_XREF CRJX,
8058: WIP_REQUIREMENT_OPERATIONS WRO,
8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,
8063: WIP_OPERATIONS WO,
8064: MTL_SERIAL_NUMBERS MSN,
8065: MTL_TRANSACTION_REASONS MTR

Line 8280: CSD_WIP_TRANSACTION_DETAILS WTD,

8276: , WTD.attribute15
8277: FROM CSD_REPAIR_JOB_XREF CRJX,
8278: WIP_OPERATION_RESOURCES WOR,
8279: WIP_ENTITIES WE,
8280: CSD_WIP_TRANSACTION_DETAILS WTD,
8281: BOM_RESOURCES BR,
8282: wip_operations wo,
8283: WIP_DISCRETE_JOBS wdj,
8284: per_all_people_f papf,

Line 8462: csd_wip_transaction_details WTD,

8458: wip_entities we,
8459: mfg_lookups ml,
8460: mtl_system_items_kfv msik,
8461: csd_service_codes_vl cscv,
8462: csd_wip_transaction_details WTD,
8463: bom_standard_operations bso
8464: WHERE
8465: CRJX.wip_entity_id = p_wip_entity_id AND
8466: WO.operation_seq_num = p_operation_seq_num AND

Line 8716: CSD_WIP_TRANSACTION_DETAILS WTD,

8712: 'N' new_row
8713: FROM CSD_REPAIR_JOB_XREF CRJX,
8714: WIP_OPERATION_RESOURCES WOR,
8715: WIP_ENTITIES WE,
8716: CSD_WIP_TRANSACTION_DETAILS WTD,
8717: BOM_RESOURCES BR,
8718: wip_operations wo,
8719: WIP_DISCRETE_JOBS wdj,
8720: per_all_people_f papf,

Line 9186: from csd_wip_transaction_details

9182: l_wip_transaction_detail_id NUMBER := NULL;
9183:
9184: cursor c_get_wip_txn_detail_id is
9185: select wip_transaction_detail_id
9186: from csd_wip_transaction_details
9187: where wip_entity_id = p_mtl_txn_dtls.wip_entity_id
9188: and inventory_item_id = p_mtl_txn_dtls.inventory_item_id
9189: and operation_seq_num = p_mtl_txn_dtls.operation_seq_num;
9190:

Line 9594: from csd_wip_transaction_details

9590: l_obj_ver_num NUMBER;
9591:
9592: cursor c_get_wip_txn_details is
9593: select wip_transaction_detail_id, inventory_item_id, resource_seq_num
9594: from csd_wip_transaction_details
9595: where wip_entity_id = p_op_dtls.wip_entity_id
9596: and operation_seq_num = p_op_dtls.operation_seq_num;
9597:
9598: cursor c_get_material_req_details (p_operation_seq_num NUMBER,

Line 9605: CSD_WIP_TRANSACTION_DETAILS csd

9601: csd.object_version_number,
9602: wip.required_quantity,
9603: nvl(wip.quantity_issued, 0)
9604: from WIP_REQUIREMENT_OPERATIONS wip,
9605: CSD_WIP_TRANSACTION_DETAILS csd
9606: where wip.wip_entity_id = p_op_dtls.wip_entity_id
9607: and wip.operation_seq_num = p_operation_seq_num
9608: and wip.inventory_item_id = p_inventory_item_id
9609: and wip.wip_entity_id = csd.wip_entity_id

Line 9680: * Now we need to delete any associated rows in csd_wip_transaction_details

9676: end if;
9677:
9678: /**
9679: * If we get this far, then WIP deletion was successful.
9680: * Now we need to delete any associated rows in csd_wip_transaction_details
9681: **/
9682:
9683: -- Get the first operation seq number for the job, just in case we need it
9684: -- during looping through the wip txn details.

Line 9773: / DELETE CSD_WIP_TRANSACTION_DETAILS ROW for the deleted operation /

9769: end if;
9770: end if;
9771: end if; -- if it is a material
9772:
9773: /** DELETE CSD_WIP_TRANSACTION_DETAILS ROW for the deleted operation **/
9774: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9775: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9776: lc_mod_name,
9777: 'Just before calling CSD_WIP_TRANSACTION_DTLS_PKG.Delete_Row');

Line 9930: UPDATE csd_wip_transaction_details SET quantity_issued = (NVL(quantity_issued,0) + p_quantity)

9926: IF p_validation_level = fnd_api.g_valid_level_none
9927: THEN
9928: IF p_transaction_type_id = 35
9929: THEN
9930: UPDATE csd_wip_transaction_details SET quantity_issued = (NVL(quantity_issued,0) + p_quantity)
9931: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id;
9932:
9933: ELSIF p_transaction_type_id = 43
9934: THEN

Line 9935: UPDATE csd_wip_transaction_details SET quantity_recovered = (NVL(quantity_recovered,0) + p_quantity)

9931: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id;
9932:
9933: ELSIF p_transaction_type_id = 43
9934: THEN
9935: UPDATE csd_wip_transaction_details SET quantity_recovered = (NVL(quantity_recovered,0) + p_quantity)
9936: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id;
9937: END IF;
9938: ELSE
9939: IF p_transaction_type_id = 35

Line 9941: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_issued = (NVL(cwt.quantity_issued,0) + p_quantity)

9937: END IF;
9938: ELSE
9939: IF p_transaction_type_id = 35
9940: THEN
9941: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_issued = (NVL(cwt.quantity_issued,0) + p_quantity)
9942: WHERE cwt.wip_transaction_detail_id = p_wip_transaction_detail_id
9943: AND EXISTS (SELECT SUM(transaction_quantity)
9944: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9945: WHERE mmt.inventory_item_id = cwt.inventory_item_id

Line 9958: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_recovered = (NVL(cwt.quantity_recovered,0) + p_quantity)

9954:
9955:
9956: ELSIF p_transaction_type_id = 43
9957: THEN
9958: UPDATE csd_wip_transaction_details cwt SET cwt.quantity_recovered = (NVL(cwt.quantity_recovered,0) + p_quantity)
9959: WHERE wip_transaction_detail_id = p_wip_transaction_detail_id
9960: AND EXISTS (SELECT SUM(transaction_quantity)
9961: FROM mtl_material_transactions mmt,wip_requirement_operations wro
9962: WHERE mmt.inventory_item_id = cwt.inventory_item_id

Line 9983: -- first we will synch up csd_wip_transaction_details with wip_requirement_operations.

9979: NULL;
9980:
9981: -- case#3. WIP entity id is provided.
9982: -- the second best case now!
9983: -- first we will synch up csd_wip_transaction_details with wip_requirement_operations.
9984: ELSIF p_wip_entity_id IS NOT NULL
9985: THEN
9986: handle_missing_mat_rqmts(p_wip_entity_id => p_wip_entity_id);
9987:

Line 9991: csd_wip_transaction_details cwt

9987:
9988: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
9989: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
9990: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
9991: csd_wip_transaction_details cwt
9992: WHERE cwt.wip_entity_id = p_wip_entity_id
9993: AND cwt.wip_entity_id = wro.wip_entity_id
9994: AND cwt.inventory_item_id = wro.inventory_item_id
9995: AND cwt.operation_seq_num = wro.operation_seq_num

Line 10007: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10003: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10004: LOOP
10005: IF l_transaction_type_ids(i) = 35
10006: THEN
10007: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10008: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10009:
10010: ELSIF l_transaction_type_ids(i) = 43
10011: THEN

Line 10012: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10008: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10009:
10010: ELSIF l_transaction_type_ids(i) = 43
10011: THEN
10012: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10013: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10014: END IF;
10015: END LOOP;
10016:

Line 10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj

10024:
10025: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10026: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10027: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10028: csd_wip_transaction_details cwt,csd_repair_job_xref crj
10029: WHERE crj.repair_line_id = p_repair_line_id
10030: AND cwt.wip_entity_id = crj.wip_entity_id
10031: AND cwt.wip_entity_id = wro.wip_entity_id
10032: AND cwt.inventory_item_id = wro.inventory_item_id

Line 10044: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10040: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10041: LOOP
10042: IF l_transaction_type_ids(i) = 35
10043: THEN
10044: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10045: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10046:
10047: ELSIF l_transaction_type_ids(i) = 43
10048: THEN

Line 10049: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10045: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10046:
10047: ELSIF l_transaction_type_ids(i) = 43
10048: THEN
10049: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10050: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10051: END IF;
10052: END LOOP;
10053:

Line 10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj

10057:
10058: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10059: BULK COLLECT INTO l_wip_transaction_detail_ids,l_transaction_type_ids,l_transaction_quantities
10060: from mtl_material_transactions mmt, wip_requirement_operations wro,
10061: csd_wip_transaction_details cwt,csd_repair_job_xref crj,wip_discrete_jobs wdj
10062: WHERE crj.repair_line_id = p_repair_line_id
10063: AND cwt.wip_entity_id = crj.wip_entity_id
10064: AND cwt.wip_entity_id = wro.wip_entity_id
10065: AND cwt.inventory_item_id = wro.inventory_item_id

Line 10079: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10075: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10076: LOOP
10077: IF l_transaction_type_ids(i) = 35
10078: THEN
10079: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10080: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10081:
10082: ELSIF l_transaction_type_ids(i) = 43
10083: THEN

Line 10084: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10080: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10081:
10082: ELSIF l_transaction_type_ids(i) = 43
10083: THEN
10084: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10085: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10086: END IF;
10087: END LOOP;
10088:

Line 10103: csd_wip_transaction_details cwt

10099: THEN
10100: OPEN l_all_jobs FOR
10101: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10102: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10103: csd_wip_transaction_details cwt
10104: WHERE cwt.wip_entity_id = wro.wip_entity_id
10105: AND cwt.inventory_item_id = wro.inventory_item_id
10106: AND cwt.operation_seq_num = wro.operation_seq_num
10107: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10118: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10114: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10115: LOOP
10116: IF l_transaction_type_ids(i) = 35
10117: THEN
10118: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10119: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10120:
10121: ELSIF l_transaction_type_ids(i) = 43
10122: THEN

Line 10123: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10119: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10120:
10121: ELSIF l_transaction_type_ids(i) = 43
10122: THEN
10123: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10124: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10125: END IF;
10126: END LOOP;
10127: EXIT WHEN l_all_jobs%NOTFOUND;

Line 10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10130: ELSE
10131: OPEN l_all_jobs FOR
10132: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10133: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10134: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10135: WHERE cwt.wip_entity_id = wro.wip_entity_id
10136: AND cwt.inventory_item_id = wro.inventory_item_id
10137: AND cwt.operation_seq_num = wro.operation_seq_num
10138: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10151: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10147: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10148: LOOP
10149: IF l_transaction_type_ids(i) = 35
10150: THEN
10151: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10152: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10153:
10154: ELSIF l_transaction_type_ids(i) = 43
10155: THEN

Line 10156: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10152: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10153:
10154: ELSIF l_transaction_type_ids(i) = 43
10155: THEN
10156: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10157: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10158: END IF;
10159: END LOOP;
10160: EXIT WHEN l_all_jobs%NOTFOUND;

Line 10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10167: THEN
10168: OPEN l_all_jobs FOR
10169: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10170: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10171: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10172: WHERE cwt.wip_entity_id = wro.wip_entity_id
10173: AND cwt.inventory_item_id = wro.inventory_item_id
10174: AND cwt.operation_seq_num = wro.operation_seq_num
10175: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10188: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10184: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10185: LOOP
10186: IF l_transaction_type_ids(i) = 35
10187: THEN
10188: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10189: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10190:
10191: ELSIF l_transaction_type_ids(i) = 43
10192: THEN

Line 10193: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10189: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10190:
10191: ELSIF l_transaction_type_ids(i) = 43
10192: THEN
10193: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10194: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10195: END IF;
10196: END LOOP;
10197: EXIT WHEN l_all_jobs%NOTFOUND;

Line 10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj

10201: ELSE
10202: OPEN l_all_jobs FOR
10203: SELECT cwt.wip_transaction_detail_id,mmt.transaction_type_id,sum(mmt.transaction_quantity)
10204: FROM mtl_material_transactions mmt, wip_requirement_operations wro,
10205: csd_wip_transaction_details cwt,wip_discrete_jobs wdj
10206: WHERE cwt.wip_entity_id = wro.wip_entity_id
10207: AND cwt.inventory_item_id = wro.inventory_item_id
10208: AND cwt.operation_seq_num = wro.operation_seq_num
10209: AND wro.inventory_item_id = mmt.inventory_item_id

Line 10223: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)

10219: FOR i IN 1 ..l_wip_transaction_detail_ids.COUNT
10220: LOOP
10221: IF l_transaction_type_ids(i) = 35
10222: THEN
10223: UPDATE csd_wip_transaction_details SET quantity_issued = l_transaction_quantities(i)
10224: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10225:
10226: ELSIF l_transaction_type_ids(i) = 43
10227: THEN

Line 10228: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)

10224: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10225:
10226: ELSIF l_transaction_type_ids(i) = 43
10227: THEN
10228: UPDATE csd_wip_transaction_details SET quantity_recovered = l_transaction_quantities(i)
10229: WHERE wip_transaction_detail_id = l_wip_transaction_detail_ids(i);
10230: END IF;
10231: END LOOP;
10232: EXIT WHEN l_all_jobs%NOTFOUND;