DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on DUAL

Line 456: SELECT pjm_unit_eff.enabled INTO g_unit_eff_enabled FROM dual;

452: -- quantity tree API, g_unit_eff_enabled is already populated.
453: -- However, we need to keep this check here since build_sql
454: -- could be called by outside APIs.
455: IF g_unit_eff_enabled IS NULL THEN
456: SELECT pjm_unit_eff.enabled INTO g_unit_eff_enabled FROM dual;
457: END IF;
458: IF g_unit_eff_enabled <> 'Y' THEN
459: l_onhand_qty_part := ' moq.primary_transaction_quantity ';
460: l_mmtt_qty_part := ' mmtt.primary_quantity ';