DBA Data[Home] [Help]

APPS.QLTDACTB dependencies on MFG_LOOKUPS

Line 314: select lookup_code from mfg_lookups

310: 'TO_INTRAOPERATION_STEP');
311: */
312:
313: Cursor MY_STEP_LOOKUP(X_MEANING VARCHAR2) is
314: select lookup_code from mfg_lookups
315: where meaning = X_MEANING
316: and lookup_type = 'WIP_INTRAOPERATION_STEP';
317:
318: Cursor MY_ASSIGNED_CHAR_ID(X_PCA_ID NUMBER, X_ACTION_ID NUMBER) is

Line 374: from mfg_lookups

370: qpca.action_id = act_id;
371:
372: CURSOR Get_priority_id(value VARCHAR2) IS
373: select lookup_code
374: from mfg_lookups
375: where lookup_type = 'WIP_EAM_ACTIVITY_PRIORITY' and
376: meaning = value;
377:
378:

Line 388: from mfg_lookups

384:
385: /*
386: CURSOR Get_operator_type(operator_number number) IS
387: select meaning
388: from mfg_lookups
389: where lookup_type = 'QA_OPERATOR' and
390: lookup_code = operator_number;
391: */
392: