APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_TXN_REQUEST_LINES

Line 4932: mtl_txn_request_lines

4928: ,l_orig_mol_rec.SECONDARY_REQUIRED_QUANTITY --OPM Convergence
4929: ,l_orig_mol_rec.backorder_delivery_detail_id
4930: ,l_orig_mol_rec.crossdock_type
4931: FROM
4932: mtl_txn_request_lines
4933: WHERE
4934: line_id = p_orig_mol_id;
4935:
4936: EXCEPTION

Line 5029: FROM mtl_txn_request_lines

5025:
5026: -- Get max line num, which is used to create unique line_num
5027: SELECT MAX(line_number)
5028: INTO l_line_num
5029: FROM mtl_txn_request_lines
5030: WHERE header_id = l_orig_mol_rec.header_id;
5031:
5032: l_progress := '50';
5033:

Line 5097: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

5093: l_new_mol_rec.secondary_quantity_detailed := 0;
5094:
5095:
5096: BEGIN
5097: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
5098: INTO l_new_mol_rec.line_id
5099: FROM dual;
5100:
5101: INSERT INTO mtl_txn_request_lines

Line 5101: INSERT INTO mtl_txn_request_lines

5097: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
5098: INTO l_new_mol_rec.line_id
5099: FROM dual;
5100:
5101: INSERT INTO mtl_txn_request_lines
5102: (
5103: LINE_ID
5104: ,HEADER_ID
5105: ,LINE_NUMBER

Line 5287: FROM mtl_txn_request_lines

5283: ,0--SECONDARY_QUANTITY_DETAILED --OPM Convergence
5284: ,WIP_ENTITY_ID --Bug 5934992
5285: ,OPERATION_SEQ_NUM --Bug 5948720
5286: ,WIP_SUPPLY_TYPE --Bug 5948720
5287: FROM mtl_txn_request_lines
5288: WHERE line_id = l_orig_mol_rec.line_id;
5289: EXCEPTION
5290: WHEN OTHERS THEN
5291: IF (l_debug = 1) THEN

Line 5533: mtl_txn_request_lines

5529:
5530: BEGIN
5531: IF (l_orig_mol_rec.SECONDARY_UOM IS NOT NULL) THEN
5532: UPDATE
5533: mtl_txn_request_lines
5534: SET
5535: primary_quantity = l_new_mol_rec.primary_quantity
5536: ,quantity = l_new_mol_rec.quantity
5537: ,quantity_delivered = l_new_mol_rec.quantity_delivered

Line 5549: mtl_txn_request_lines

5545: WHERE
5546: line_id = l_new_mol_rec.line_id;
5547: ELSE
5548: UPDATE
5549: mtl_txn_request_lines
5550: SET
5551: primary_quantity = l_new_mol_rec.primary_quantity
5552: ,quantity = l_new_mol_rec.quantity
5553: ,quantity_delivered = l_new_mol_rec.quantity_delivered

Line 5638: mtl_txn_request_lines

5634: l_progress := '200';
5635: BEGIN
5636: IF (l_orig_mol_rec.SECONDARY_UOM IS NOT NULL) THEN
5637: UPDATE
5638: mtl_txn_request_lines
5639: SET
5640: primary_quantity = l_orig_mol_rec.primary_quantity
5641: ,quantity = l_orig_mol_rec.quantity
5642: ,quantity_delivered = l_orig_mol_rec.quantity_delivered

Line 5653: mtl_txn_request_lines

5649: WHERE
5650: line_id = l_orig_mol_rec.line_id;
5651: ELSE
5652: UPDATE
5653: mtl_txn_request_lines
5654: SET
5655: primary_quantity = l_orig_mol_rec.primary_quantity
5656: ,quantity = l_orig_mol_rec.quantity
5657: ,quantity_delivered = l_orig_mol_rec.quantity_delivered