DBA Data[Home] [Help]

APPS.GMO_INSTRUCTION_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 5828: FND_LOOKUP_VALUES_VL LK

5824: INSTR_SET.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,
5825: (SELECT
5826: LK.MEANING
5827: FROM
5828: FND_LOOKUP_VALUES_VL LK
5829: WHERE
5830: LK.LOOKUP_TYPE = 'GMO_INSTR_'||INSTR_SET.ENTITY_NAME
5831: AND
5832: LK.LOOKUP_CODE = INSTR_SET.INSTRUCTION_TYPE) AS INSTRUCTION_TYPE,

Line 5840: FND_LOOKUP_VALUES_VL LK1

5836: INSTR.INSTRUCTION_TEXT AS INSTRUCTION_TEXT,
5837: (SELECT
5838: LK1.MEANING
5839: FROM
5840: FND_LOOKUP_VALUES_VL LK1
5841: WHERE
5842: LK1.LOOKUP_TYPE = 'GMO_INSTR_ACKN_TYPES'
5843: AND
5844: LK1.LOOKUP_CODE = INSTR.INSTR_ACKN_TYPE) AS INSTRUCTION_ACKN_TYPE,

Line 6251: FND_LOOKUP_VALUES_VL LK

6247: INSTR_SETVL.INSTR_SET_DESC AS INSTRUCTION_SET_DESC,
6248: (SELECT
6249: LK.MEANING
6250: FROM
6251: FND_LOOKUP_VALUES_VL LK
6252: WHERE
6253: LK.LOOKUP_TYPE = 'GMO_INSTR_'||INSTR_SETVL.ENTITY_NAME
6254: AND
6255: LK.LOOKUP_CODE = INSTR_SETVL.INSTRUCTION_TYPE) AS INSTRUCTION_TYPE,

Line 6261: FND_LOOKUP_VALUES_VL LK1

6257: XMLAGG(XMLELEMENT("INSTRUCTION_DETAILS",XMLFOREST(INSTRVL.INSTRUCTION_TEXT,
6258: (SELECT
6259: MEANING
6260: FROM
6261: FND_LOOKUP_VALUES_VL LK1
6262: WHERE
6263: LK1.LOOKUP_TYPE = 'GMO_INSTR_STATUS_TYPES'
6264: AND
6265: LK1.LOOKUP_CODE = INSTR.INSTR_STATUS) AS INSTRUCTION_STATUS,

Line 6269: FND_LOOKUP_VALUES_VL LK2

6265: LK1.LOOKUP_CODE = INSTR.INSTR_STATUS) AS INSTRUCTION_STATUS,
6266: (SELECT
6267: MEANING
6268: FROM
6269: FND_LOOKUP_VALUES_VL LK2
6270: WHERE
6271: LK2.LOOKUP_TYPE = 'GMO_INSTR_ACKN_TYPES'
6272: AND LK2.LOOKUP_CODE = INSTRVL.INSTR_ACKN_TYPE)
6273: AS INSTRUCTION_ACKN_TYPE,