APPS.INV_MO_ADMIN_PUB dependencies on MTL_TXN_REQUEST_LINES

Line 218: FROM mtl_txn_request_lines

214: IF ( l_hdr_status in (2,4,8)) THEN
215: Begin
216: SELECT 1
217: INTO l_line_status
218: FROM mtl_txn_request_lines
219: WHERE header_id = l_header_id
220: AND line_status in (1,2,8)
221: AND ROWNUM = 1;
222: Exception

Line 367: Delete MTL_TXN_REQUEST_LINES

363: FND_MSG_PUB.ADD;
364: RAISE FND_API.G_EXC_ERROR;
365: END IF;
366:
367: Delete MTL_TXN_REQUEST_LINES
368: where
369: header_id = l_header_id;
370:
371: Delete MTL_TXN_REQUEST_HEADERS

Line 478: FROM mtl_txn_request_lines_v

474: --Need to lock the record while updating the MOL since any other form
475: --should not hang and should show the correct exception.
476: SELECT line_status, quantity_delivered, move_order_type, organization_id
477: INTO l_line_status, l_qty_del, l_mo_type, l_org_id
478: FROM mtl_txn_request_lines_v
479: WHERE Line_Id = l_Line_Id
480: FOR UPDATE NOWAIT;
481: EXCEPTION
482: WHEN No_Data_Found THEN

Line 675: FROM mtl_txn_request_lines

671: --Need to lock the record while updating the MOL since any other form
672: --should not hang and should show the correct exception.
673: SELECT line_status, quantity_delivered, quantity ,organization_id
674: INTO l_line_status, l_qty_del, l_qty, l_org_id
675: FROM mtl_txn_request_lines
676: WHERE Line_Id = l_Line_Id
677: FOR UPDATE NOWAIT;
678: EXCEPTION
679: WHEN No_Data_Found THEN

Line 757: Update MTL_TXN_REQUEST_LINES

753:
754:
755: IF l_loaded_lpn_exists = 1 then
756:
757: Update MTL_TXN_REQUEST_LINES
758: set line_status = 9,
759: last_updated_by = fnd_global.user_id,
760: last_update_login = fnd_global.login_id,
761: last_update_date = sysdate,

Line 779: Update MTL_TXN_REQUEST_LINES

775: END;
776:
777:
778: -- Updating the who columns for bug 3277406
779: Update MTL_TXN_REQUEST_LINES
780: set line_status = 5,
781: last_updated_by = fnd_global.user_id,
782: last_update_login = fnd_global.login_id,
783: last_update_date = sysdate,