APPS.QLTTRAWB dependencies on FND_USER_VIEW

Line 4740: FROM FND_USER_VIEW

4736: -- and qa_last_updated_by_name if they are null.
4737:
4738: SELECT USER_NAME
4739: INTO X_USER_NAME
4740: FROM FND_USER_VIEW
4741: WHERE USER_ID = X_USER_ID;
4742:
4743: -- set qa_created_by_name and _id to the current user if they are null
4744:

Line 4797: FROM FND_USER_VIEW FU2

4793: QRI.TRANSACTION_INTERFACE_ID
4794: AND QIE.ERROR_COLUMN IN ('QA_CREATED_BY_NAME', NULL))
4795: AND NOT EXISTS
4796: (SELECT 'X'
4797: FROM FND_USER_VIEW FU2
4798: WHERE QRI.QA_CREATED_BY_NAME = FU2.USER_NAME);
4799:
4800: -- in the above where, we should really be checking start_
4801: -- and end_date to make sure it is a current user. the

Line 4822: FROM FND_USER_VIEW FU2

4818: PROGRAM_ID = X_PROGRAM_ID,
4819: PROGRAM_UPDATE_DATE = SYSDATE,
4820: QA_CREATED_BY =
4821: (SELECT MIN(FU2.USER_ID)
4822: FROM FND_USER_VIEW FU2
4823: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME),
4824: QA_LAST_UPDATED_BY =
4825: (SELECT MIN(FU2.USER_ID)
4826: FROM FND_USER_VIEW FU2

Line 4826: FROM FND_USER_VIEW FU2

4822: FROM FND_USER_VIEW FU2
4823: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME),
4824: QA_LAST_UPDATED_BY =
4825: (SELECT MIN(FU2.USER_ID)
4826: FROM FND_USER_VIEW FU2
4827: WHERE FU2.USER_NAME = QRI.QA_CREATED_BY_NAME)
4828: WHERE QRI.GROUP_ID = X_GROUP_ID
4829: AND QRI.PROCESS_STATUS = 2
4830: AND QRI.INSERT_TYPE <> 2 -- added for 3663648

Line 4880: FROM FND_USER_VIEW FU2

4876: QRI.TRANSACTION_INTERFACE_ID
4877: AND QIE.ERROR_COLUMN IN ('QA_LAST_UPDATED_BY_NAME', NULL))
4878: AND NOT EXISTS
4879: (SELECT 'X'
4880: FROM FND_USER_VIEW FU2
4881: WHERE QRI.QA_LAST_UPDATED_BY_NAME = FU2.USER_NAME);
4882:
4883: -- in the above where, we should really be checking start_
4884: -- and end_date to make sure it is a current user. the

Line 4905: FROM FND_USER_VIEW FU2

4901: PROGRAM_ID = X_PROGRAM_ID,
4902: PROGRAM_UPDATE_DATE = SYSDATE,
4903: QA_LAST_UPDATED_BY=
4904: (SELECT MIN(FU2.USER_ID)
4905: FROM FND_USER_VIEW FU2
4906: WHERE FU2.USER_NAME = QRI.QA_LAST_UPDATED_BY_NAME)
4907: WHERE QRI.GROUP_ID = X_GROUP_ID
4908: AND QRI.PROCESS_STATUS = 2
4909: AND QRI.INSERT_TYPE = 2 -- added for 3663648

Line 7714: FROM FND_USER_VIEW

7710:
7711: -- get the current user name.
7712: SELECT USER_NAME
7713: INTO X_USER_NAME
7714: FROM FND_USER_VIEW
7715: WHERE USER_ID = X_USER_ID;
7716:
7717: -- update who columns and org_id
7718: UPDATE QA_RESULTS_INTERFACE QRI