APPS.CSM_EMAIL_QUERY_PKG dependencies on FND_LOOKUP_VALUES

Line 1294: FROM fnd_lookup_values

1290:
1291: CURSOR c_note_status(p_meaning VARCHAR2)
1292: IS
1293: SELECT lookup_code
1294: FROM fnd_lookup_values
1295: WHERE lookup_type = 'JTF_NOTE_STATUS'
1296: AND meaning = p_meaning
1297: AND language = userenv('LANG');
1298:

Line 1517: fnd_lookup_values lkp

1513: FROM jtf_tasks_b tsk,
1514: jtf_notes_b ntb,
1515: jtf_notes_tl nttl,
1516: jtf_rs_resource_extns rs,
1517: fnd_lookup_values lkp
1518: WHERE tsk.task_number = p_task_number
1519: AND ntb.source_object_id = tsk.task_id
1520: AND ntb.source_object_code = 'TASK'
1521: AND nttl.jtf_note_id = ntb.jtf_note_id

Line 1692: FROM fnd_lookup_values

1688:
1689: CURSOR c_problem_summary(p_problem_code VARCHAR2)
1690: IS
1691: SELECT description
1692: FROM fnd_lookup_values
1693: WHERE lookup_code = p_problem_code
1694: AND lookup_type = 'REQUEST_PROBLEM_CODE'
1695: AND LANGUAGE = userenv('LANG');
1696:

Line 1700: FROM fnd_lookup_values

1696:
1697: CURSOR c_resolution_summary(p_resolution_code VARCHAR2)
1698: IS
1699: SELECT description
1700: FROM fnd_lookup_values
1701: WHERE lookup_code = p_resolution_code
1702: AND lookup_type = 'REQUEST_RESOLUTION_CODE'
1703: AND LANGUAGE = userenv('LANG');
1704:

Line 1715: fnd_lookup_values lkp

1711: FROM cs_incidents_all_b cs,
1712: jtf_notes_b ntb,
1713: jtf_notes_tl nttl,
1714: jtf_rs_resource_extns rs,
1715: fnd_lookup_values lkp
1716: WHERE cs.incident_number = p_incident_number
1717: AND ntb.source_object_id = cs.incident_id
1718: AND ntb.source_object_code = 'SR'
1719: AND nttl.jtf_note_id = ntb.jtf_note_id

Line 1730: l_description fnd_lookup_values.description%TYPE;

1726: r_incident_details c_incident_details%ROWTYPE;
1727: l_item mtl_system_items_b.segment1%TYPE;
1728: l_instance_number csi_item_instances.instance_number%TYPE;
1729: l_serial_number csi_item_instances.serial_number%TYPE;
1730: l_description fnd_lookup_values.description%TYPE;
1731: r_sr_notes c_sr_notes%ROWTYPE;
1732: l_incident_id NUMBER;
1733: l_query_text VARCHAR2(4000);
1734: qrycontext DBMS_XMLGEN.ctxHandle;

Line 2166: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2162: IS
2163: SELECT
2164: B.SEGMENT1,
2165: TL.DESCRIPTION,
2166: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2167: LOOKUP_TYPE = 'CSP_RECOVERED_PART_DISP_CODE'
2168: AND LOOKUP_CODE = B.RECOVERED_PART_DISP_CODE
2169: AND LANGUAGE = USERENV('LANG')
2170: ) AS PART_DISPOSITION,

Line 2172: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2168: AND LOOKUP_CODE = B.RECOVERED_PART_DISP_CODE
2169: AND LANGUAGE = USERENV('LANG')
2170: ) AS PART_DISPOSITION,
2171: DECODE(NVL(B.REVISION_QTY_CONTROL_CODE,'1'),'2', 'Yes','1','No') AS REVISION,
2172: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2173: LOOKUP_TYPE = 'MTL_LOCATOR_RESTRICTIONS'
2174: AND LOOKUP_CODE = B.RESTRICT_LOCATORS_CODE
2175: AND LANGUAGE = USERENV('LANG')
2176: ) AS RESTRICT_LOCATORS_CODE

Line 2179: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2175: AND LANGUAGE = USERENV('LANG')
2176: ) AS RESTRICT_LOCATORS_CODE
2177: ,
2178:
2179: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2180: LOOKUP_TYPE = 'MTL_SUBINVENTORY_RESTRICTIONS'
2181: AND LOOKUP_CODE = B.RESTRICT_SUBINVENTORIES_CODE
2182: AND LANGUAGE = USERENV('LANG')
2183: ) AS RESTRICT_SUBINVENTORIES_CODE,

Line 2185: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2181: AND LOOKUP_CODE = B.RESTRICT_SUBINVENTORIES_CODE
2182: AND LANGUAGE = USERENV('LANG')
2183: ) AS RESTRICT_SUBINVENTORIES_CODE,
2184:
2185: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2186: LOOKUP_TYPE = 'MTL_LOCATION_CONTROL'
2187: AND LOOKUP_CODE = B.LOCATION_CONTROL_CODE
2188: AND LANGUAGE = USERENV('LANG')
2189: ) AS LOCATION_CONTROL_CODE,

Line 2191: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2187: AND LOOKUP_CODE = B.LOCATION_CONTROL_CODE
2188: AND LANGUAGE = USERENV('LANG')
2189: ) AS LOCATION_CONTROL_CODE,
2190:
2191: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2192: LOOKUP_TYPE = 'MTL_LOT_CONTROL'
2193: AND LOOKUP_CODE = B.LOT_CONTROL_CODE
2194: AND LANGUAGE = USERENV('LANG')
2195: ) AS LOT_CONTROL_CODE,

Line 2197: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2193: AND LOOKUP_CODE = B.LOT_CONTROL_CODE
2194: AND LANGUAGE = USERENV('LANG')
2195: ) AS LOT_CONTROL_CODE,
2196:
2197: (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2198: LOOKUP_TYPE = 'MTL_SERIAL_NUMBER'
2199: AND LOOKUP_CODE = B.SERIAL_NUMBER_CONTROL_CODE
2200: AND LANGUAGE = USERENV('LANG')
2201: ) AS SERIAL_NUMBER_CONTROL_CODE ,

Line 2297: TL.DESCRIPTION,(SELECT MEANING FROM FND_LOOKUP_VALUES WHERE

2293:
2294: CURSOR c_get_sub(p_inv_item_id NUMBER, p_org_id NUMBER)
2295: IS
2296: SELECT B.SEGMENT1,
2297: TL.DESCRIPTION,(SELECT MEANING FROM FND_LOOKUP_VALUES WHERE
2298: LOOKUP_TYPE = 'MTL_RELATIONSHIP_TYPES'
2299: AND LOOKUP_CODE = R.RELATIONSHIP_TYPE_ID
2300: AND LANGUAGE = USERENV('LANG')
2301: ) AS ITEM_TYPE,