DBA Data[Home] [Help]

APPS.ENG_WORKFLOW_API_PKG dependencies on MFG_LOOKUPS

Line 236: (SELECT meaning FROM mfg_lookups WHERE eec.status_type = lookup_code

232: /* Fix for bug 5215778- Added task_id, project_id to the select statement.
233: Fix for bug 5200489- In the where clause, replaced person_id with party_id in the join between eec and mev */
234:
235: SELECT eec.description,
236: (SELECT meaning FROM mfg_lookups WHERE eec.status_type = lookup_code
237: AND lookup_type = 'ECG_ECN_STATUS'), /* eco status */
238: eec.initiation_date,
239: eec.priority_code,
240: eec.reason_code,

Line 259: (SELECT meaning FROM mfg_lookups WHERE eec.approval_status_type =

255: eec.attribute12,
256: eec.attribute13,
257: eec.attribute14,
258: eec.attribute15,
259: (SELECT meaning FROM mfg_lookups WHERE eec.approval_status_type =
260: lookup_code
261: AND lookup_type = 'ENG_ECN_APPROVAL_STATUS'), /*approval status*/
262: (SELECT organization_code FROM mtl_parameters WHERE
263: organization_id=eec.organization_id),