DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_PVT dependencies on FND_LOOKUP_VALUES

Line 315: FROM fnd_lookup_values fa_lookup

311: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
312: AND
313: first_article_status NOT IN
314: (SELECT lookup_code
315: FROM fnd_lookup_values fa_lookup
316: WHERE fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_FST_ATCLE_STS'
317: AND fa_lookup.language = G_SESSION_LANG)
318: )
319: OR

Line 327: FROM fnd_lookup_values fa_lookup

323: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
324: AND
325: first_article_status_meaning NOT IN
326: (SELECT meaning
327: FROM fnd_lookup_values fa_lookup
328: WHERE fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_FST_ATCLE_STS'
329: AND fa_lookup.language = G_SESSION_LANG)
330: )
331: );

Line 338: from fnd_lookup_values fa_lookup

334: SET first_article_status =
335: DECODE (first_article_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
336: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
337: (Select lookup_code
338: from fnd_lookup_values fa_lookup
339: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_FST_ATCLE_STS'
340: and fa_lookup.meaning = aml_intf.first_article_status_meaning
341: and fa_lookup.language = G_SESSION_LANG)
342: )

Line 363: FROM fnd_lookup_values fa_lookup

359: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
360: AND
361: approval_status NOT IN
362: (SELECT lookup_code
363: FROM fnd_lookup_values fa_lookup
364: WHERE fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_APPR_STS'
365: AND fa_lookup.language = G_SESSION_LANG)
366: )
367: OR

Line 375: FROM fnd_lookup_values fa_lookup

371: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
372: AND
373: approval_status_meaning NOT IN
374: (SELECT meaning
375: FROM fnd_lookup_values fa_lookup
376: WHERE fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_APPR_STS'
377: AND fa_lookup.language = G_SESSION_LANG)
378: )
379: );

Line 386: from fnd_lookup_values fa_lookup

382: SET approval_status =
383: DECODE (approval_status_meaning, EGO_ITEM_PUB.G_INTF_NULL_CHAR,
384: EGO_ITEM_PUB.G_INTF_NULL_CHAR,
385: (Select lookup_code
386: from fnd_lookup_values fa_lookup
387: where fa_lookup.lookup_type = 'EGO_CAT_GRP_MFG_APPR_STS'
388: and fa_lookup.meaning = aml_intf.approval_status_meaning
389: and fa_lookup.language = G_SESSION_LANG)
390: )