eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_FULL_PEGGING

Line 748: from msc_full_pegging mfp1,

744: FUNCTION child_supplies_onhand(p_plan_id number,
745: p_transaction_id number) return number IS
746: CURSOR child_supply_c is
747: SELECT 1
748: from msc_full_pegging mfp1,
749: msc_full_pegging mfp2,
750: msc_supplies ms
751: where mfp1.plan_id = p_plan_id
752: and mfp1.transaction_id = p_transaction_id

Line 749: msc_full_pegging mfp2,

745: p_transaction_id number) return number IS
746: CURSOR child_supply_c is
747: SELECT 1
748: from msc_full_pegging mfp1,
749: msc_full_pegging mfp2,
750: msc_supplies ms
751: where mfp1.plan_id = p_plan_id
752: and mfp1.transaction_id = p_transaction_id
753: and mfp2.plan_id = mfp1.plan_id