APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_TXN_REQUEST_LINES

Line 4863: mtl_txn_request_lines

4859: ,l_orig_mol_rec.SECONDARY_REQUIRED_QUANTITY --OPM Convergence
4860: ,l_orig_mol_rec.backorder_delivery_detail_id
4861: ,l_orig_mol_rec.crossdock_type
4862: FROM
4863: mtl_txn_request_lines
4864: WHERE
4865: line_id = p_orig_mol_id;
4866:
4867: EXCEPTION

Line 4960: FROM mtl_txn_request_lines

4956:
4957: -- Get max line num, which is used to create unique line_num
4958: SELECT MAX(line_number)
4959: INTO l_line_num
4960: FROM mtl_txn_request_lines
4961: WHERE header_id = l_orig_mol_rec.header_id;
4962:
4963: l_progress := '50';
4964:

Line 5028: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL

5024: l_new_mol_rec.secondary_quantity_detailed := 0;
5025:
5026:
5027: BEGIN
5028: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
5029: INTO l_new_mol_rec.line_id
5030: FROM dual;
5031:
5032: INSERT INTO mtl_txn_request_lines

Line 5032: INSERT INTO mtl_txn_request_lines

5028: SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
5029: INTO l_new_mol_rec.line_id
5030: FROM dual;
5031:
5032: INSERT INTO mtl_txn_request_lines
5033: (
5034: LINE_ID
5035: ,HEADER_ID
5036: ,LINE_NUMBER

Line 5218: FROM mtl_txn_request_lines

5214: ,0--SECONDARY_QUANTITY_DETAILED --OPM Convergence
5215: ,WIP_ENTITY_ID --Bug 5934992
5216: ,OPERATION_SEQ_NUM --Bug 5948720
5217: ,WIP_SUPPLY_TYPE --Bug 5948720
5218: FROM mtl_txn_request_lines
5219: WHERE line_id = l_orig_mol_rec.line_id;
5220: EXCEPTION
5221: WHEN OTHERS THEN
5222: IF (l_debug = 1) THEN

Line 5464: mtl_txn_request_lines

5460:
5461: BEGIN
5462: IF (l_orig_mol_rec.SECONDARY_UOM IS NOT NULL) THEN
5463: UPDATE
5464: mtl_txn_request_lines
5465: SET
5466: primary_quantity = l_new_mol_rec.primary_quantity
5467: ,quantity = l_new_mol_rec.quantity
5468: ,quantity_delivered = l_new_mol_rec.quantity_delivered

Line 5480: mtl_txn_request_lines

5476: WHERE
5477: line_id = l_new_mol_rec.line_id;
5478: ELSE
5479: UPDATE
5480: mtl_txn_request_lines
5481: SET
5482: primary_quantity = l_new_mol_rec.primary_quantity
5483: ,quantity = l_new_mol_rec.quantity
5484: ,quantity_delivered = l_new_mol_rec.quantity_delivered

Line 5569: mtl_txn_request_lines

5565: l_progress := '200';
5566: BEGIN
5567: IF (l_orig_mol_rec.SECONDARY_UOM IS NOT NULL) THEN
5568: UPDATE
5569: mtl_txn_request_lines
5570: SET
5571: primary_quantity = l_orig_mol_rec.primary_quantity
5572: ,quantity = l_orig_mol_rec.quantity
5573: ,quantity_delivered = l_orig_mol_rec.quantity_delivered

Line 5584: mtl_txn_request_lines

5580: WHERE
5581: line_id = l_orig_mol_rec.line_id;
5582: ELSE
5583: UPDATE
5584: mtl_txn_request_lines
5585: SET
5586: primary_quantity = l_orig_mol_rec.primary_quantity
5587: ,quantity = l_orig_mol_rec.quantity
5588: ,quantity_delivered = l_orig_mol_rec.quantity_delivered