APPS.QLTTRAWB dependencies on FND_USER_VIEW

Line 5071: FROM FND_USER_VIEW

5067: -- and qa_last_updated_by_name if they are null.
5068:
5069: SELECT USER_NAME
5070: INTO X_USER_NAME
5071: FROM FND_USER_VIEW
5072: WHERE USER_ID = X_USER_ID;
5073:
5074: -- set qa_created_by_name and _id to the current user if they are null
5075:

Line 5128: FROM FND_USER_VIEW FU2

5124: QRI.TRANSACTION_INTERFACE_ID
5125: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL))
5126: AND NOT EXISTS
5127: (SELECT 'X'
5128: FROM FND_USER_VIEW FU2
5129: WHERE QRI.QA_CREATED_BY_NAME = FU2.USER_NAME);
5130:
5131: If (sql%rowcount >0) THEN
5132: QLTTRAMB.qa_import_log('Error in created by Error count :' ||sql%rowcount);

Line 5157: FROM FND_USER_VIEW FU2

5153: PROGRAM_ID = X_PROGRAM_ID,
5154: PROGRAM_UPDATE_DATE = SYSDATE,
5155: QA_CREATED_BY =
5156: (SELECT MIN(FU2.USER_ID)
5157: FROM FND_USER_VIEW FU2
5158: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME),
5159: QA_LAST_UPDATED_BY =
5160: (SELECT MIN(FU2.USER_ID)
5161: FROM FND_USER_VIEW FU2

Line 5161: FROM FND_USER_VIEW FU2

5157: FROM FND_USER_VIEW FU2
5158: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME),
5159: QA_LAST_UPDATED_BY =
5160: (SELECT MIN(FU2.USER_ID)
5161: FROM FND_USER_VIEW FU2
5162: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME)
5163: WHERE QRI.GROUP_ID = X_GROUP_ID
5164: AND QRI.PROCESS_STATUS = 2
5165: AND QRI.INSERT_TYPE <> 2 -- added for 3663648

Line 5215: FROM FND_USER_VIEW FU2

5211: QRI.TRANSACTION_INTERFACE_ID
5212: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL))
5213: AND NOT EXISTS
5214: (SELECT 'X'
5215: FROM FND_USER_VIEW FU2
5216: WHERE QRI.QA_LAST_UPDATED_BY_NAME = FU2.USER_NAME);
5217:
5218: If (sql%rowcount >0) THEN
5219: QLTTRAMB.qa_import_log('Error in last updated by Error count :' ||sql%rowcount);

Line 5244: FROM FND_USER_VIEW FU2

5240: PROGRAM_ID = X_PROGRAM_ID,
5241: PROGRAM_UPDATE_DATE = SYSDATE,
5242: QA_LAST_UPDATED_BY=
5243: (SELECT MIN(FU2.USER_ID)
5244: FROM FND_USER_VIEW FU2
5245: WHERE FU2.USER_NAME = QRI.QA_LAST_UPDATED_BY_NAME)
5246: WHERE QRI.GROUP_ID = X_GROUP_ID
5247: AND QRI.PROCESS_STATUS = 2
5248: AND QRI.INSERT_TYPE = 2 -- added for 3663648

Line 8230: FROM FND_USER_VIEW

8226:
8227: -- get the current user name.
8228: SELECT USER_NAME
8229: INTO X_USER_NAME
8230: FROM FND_USER_VIEW
8231: WHERE USER_ID = X_USER_ID;
8232:
8233: -- update who columns and org_id
8234: UPDATE QA_RESULTS_INTERFACE QRI