DBA Data[Home] [Help]

APPS.EDR_UTILITIES dependencies on WF_LOOKUPS

Line 617: (SELECT D.MEANING FROM WF_LOOKUPS D WHERE D.LOOKUP_CODE=A.SIGNATURE_REASON_CODE AND

613: select SIGNATURE_SEQUENCE,USER_NAME,
614: B.MEANING SIGNATURE_STATUS,
615: SIGNATURE_TIMESTAMP,
616: C.MEANING SIGNATURE_TYPE,
617: (SELECT D.MEANING FROM WF_LOOKUPS D WHERE D.LOOKUP_CODE=A.SIGNATURE_REASON_CODE AND
618: D.LOOKUP_TYPE='SIGNING_REASON_CODES') SIGNATURE_REASON_CODE,
619: SIGNER_COMMENTS,
620: --Bug 4113995: Start
621: --Including overriding comments in the cursor.

Line 626: WF_LOOKUPS C

622: SIGNATURE_OVERRIDING_COMMENTS
623: --Bug 4113995: End
624: from EDR_ESIGNATURES A,
625: FND_LOOKUPS B,
626: WF_LOOKUPS C
627: WHERE EVENT_ID=to_number(document_id,'999999999999.999999' ) AND
628: A.SIGNATURE_STATUS=B.LOOKUP_CODE AND
629: B.LOOKUP_TYPE='EDR_PSIG_ESIGNATURE' AND
630: C.LOOKUP_CODE=A.SIGNATURE_TYPE AND