APPS.INV_MO_ADMIN_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 213: FROM mtl_txn_request_lines

209: IF ( l_hdr_status in (2,4,8)) THEN
210: Begin
211: SELECT 1
212: INTO l_line_status
213: FROM mtl_txn_request_lines
214: WHERE header_id = l_header_id
215: AND line_status in (1,2,8)
216: AND ROWNUM = 1;
217: Exception

Line 357: Delete MTL_TXN_REQUEST_LINES

353: FND_MSG_PUB.ADD;
354: RAISE FND_API.G_EXC_ERROR;
355: END IF;
356:
357: Delete MTL_TXN_REQUEST_LINES
358: where
359: header_id = l_header_id;
360:
361: Delete MTL_TXN_REQUEST_HEADERS

Line 468: FROM mtl_txn_request_lines_v

464: --Need to lock the record while updating the MOL since any other form
465: --should not hang and should show the correct exception.
466: SELECT line_status, quantity_delivered, move_order_type, organization_id
467: INTO l_line_status, l_qty_del, l_mo_type, l_org_id
468: FROM mtl_txn_request_lines_v
469: WHERE Line_Id = l_Line_Id
470: FOR UPDATE NOWAIT;
471: EXCEPTION
472: WHEN No_Data_Found THEN

Line 665: FROM mtl_txn_request_lines

661: --Need to lock the record while updating the MOL since any other form
662: --should not hang and should show the correct exception.
663: SELECT line_status, quantity_delivered, quantity ,organization_id
664: INTO l_line_status, l_qty_del, l_qty, l_org_id
665: FROM mtl_txn_request_lines
666: WHERE Line_Id = l_Line_Id
667: FOR UPDATE NOWAIT;
668: EXCEPTION
669: WHEN No_Data_Found THEN

Line 747: Update MTL_TXN_REQUEST_LINES

743:
744:
745: IF l_loaded_lpn_exists = 1 then
746:
747: Update MTL_TXN_REQUEST_LINES
748: set line_status = 9,
749: last_updated_by = fnd_global.user_id,
750: last_update_login = fnd_global.login_id,
751: last_update_date = sysdate,

Line 769: Update MTL_TXN_REQUEST_LINES

765: END;
766:
767:
768: -- Updating the who columns for bug 3277406
769: Update MTL_TXN_REQUEST_LINES
770: set line_status = 5,
771: last_updated_by = fnd_global.user_id,
772: last_update_login = fnd_global.login_id,
773: last_update_date = sysdate,