DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 5850: FND_LOOKUP_VALUES_VL LK

5846: INSTR_SET.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,
5847: (SELECT
5848: LK.MEANING
5849: FROM
5850: FND_LOOKUP_VALUES_VL LK
5851: WHERE
5852: LK.LOOKUP_TYPE = 'GMO_INSTR_'||INSTR_SET.ENTITY_NAME
5853: AND
5854: LK.LOOKUP_CODE = INSTR_SET.INSTRUCTION_TYPE) AS INSTRUCTION_TYPE,

Line 5862: FND_LOOKUP_VALUES_VL LK1

5858: INSTR.INSTRUCTION_TEXT AS INSTRUCTION_TEXT,
5859: (SELECT
5860: LK1.MEANING
5861: FROM
5862: FND_LOOKUP_VALUES_VL LK1
5863: WHERE
5864: LK1.LOOKUP_TYPE = 'GMO_INSTR_ACKN_TYPES'
5865: AND
5866: LK1.LOOKUP_CODE = INSTR.INSTR_ACKN_TYPE) AS INSTRUCTION_ACKN_TYPE,

Line 6274: FND_LOOKUP_VALUES_VL LK

6270: INSTR_SETVL.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,
6271: (SELECT
6272: LK.MEANING
6273: FROM
6274: FND_LOOKUP_VALUES_VL LK
6275: WHERE
6276: LK.LOOKUP_TYPE = 'GMO_INSTR_'||INSTR_SETVL.ENTITY_NAME
6277: AND
6278: LK.LOOKUP_CODE = INSTR_SETVL.INSTRUCTION_TYPE) AS INSTRUCTION_TYPE,

Line 6284: FND_LOOKUP_VALUES_VL LK1

6280: XMLAGG(XMLELEMENT("INSTRUCTION_DETAILS",XMLFOREST(INSTRVL.INSTRUCTION_TEXT,
6281: (SELECT
6282: MEANING
6283: FROM
6284: FND_LOOKUP_VALUES_VL LK1
6285: WHERE
6286: LK1.LOOKUP_TYPE = 'GMO_INSTR_STATUS_TYPES'
6287: AND
6288: LK1.LOOKUP_CODE = INSTR.INSTR_STATUS) AS INSTRUCTION_STATUS,

Line 6292: FND_LOOKUP_VALUES_VL LK2

6288: LK1.LOOKUP_CODE = INSTR.INSTR_STATUS) AS INSTRUCTION_STATUS,
6289: (SELECT
6290: MEANING
6291: FROM
6292: FND_LOOKUP_VALUES_VL LK2
6293: WHERE
6294: LK2.LOOKUP_TYPE = 'GMO_INSTR_ACKN_TYPES'
6295: AND LK2.LOOKUP_CODE = INSTRVL.INSTR_ACKN_TYPE)
6296: AS INSTRUCTION_ACKN_TYPE,