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_REL_PLAN_PUB dependencies on MSC_PART_SUPPLIES

Line 2651: 'msc_part_supplies s, '||

2647: ' msc_trading_partners mp, ' ||
2648: ' msc_trading_partners mp2, ' ||
2649: 'msc_system_items msi, '||
2650: 'msc_system_items msi1,'||
2651: 'msc_part_supplies s, '||
2652: 'msc_plan_organizations_v orgs '||
2653: 'WHERE mpp.organization_id (+)= s.organization_id '||
2654: 'AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
2655: 'AND mpp.plan_id (+)= s.plan_id '||

Line 2723: from msc_part_supplies ms, msc_single_lvl_peg mslp

2719: END IF;
2720:
2721: /* update mrp_org_transfer_release motr
2722: set earliest_ship_date = (select max(ms.new_schedule_date)
2723: from msc_part_supplies ms, msc_single_lvl_peg mslp
2724: where ms.plan_id=l_arg_plan_id
2725: and ms.transaction_id = mslp.child_id
2726: and ms.plan_id= mslp.plan_id
2727: and mslp.parent_id = motr.transaction_id

Line 2741: /* update msc_part_supplies

2737: batch_id = nvl(batch_id,g_batch_id)
2738: where plan_id = l_arg_plan_id
2739: and transaction_id= l_arg_transaction_id;
2740:
2741: /* update msc_part_supplies
2742: set releasable = RELEASE_ATTEMPTED,
2743: batch_id = nvl(batch_id,g_batch_id)
2744: where plan_id = l_arg_plan_id
2745: and transaction_id= l_arg_transaction_id; */

Line 2751: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

2747: execute immediate ' update msc_supplies
2748: set releasable = ' || RELEASE_ATTEMPTED || ',
2749: batch_id = nvl(batch_id,' ||g_batch_id ||')
2750: where plan_id = ' || l_arg_plan_id || '
2751: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
2752: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
2753: where batch_id = ' || l_arg_po_batch_number || '))';
2754:
2755: execute immediate ' update msc_part_supplies

Line 2755: execute immediate ' update msc_part_supplies

2751: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
2752: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
2753: where batch_id = ' || l_arg_po_batch_number || '))';
2754:
2755: execute immediate ' update msc_part_supplies
2756: set releasable = ' || RELEASE_ATTEMPTED || ',
2757: batch_id = nvl(batch_id,' ||g_batch_id ||')
2758: where plan_id = ' || l_arg_plan_id || '
2759: and transaction_id in

Line 3201: msc_part_supplies s,

3197: s.implement_source_org_id,
3198: k.transaction_id
3199: FROM
3200: msc_supplies k,
3201: msc_part_supplies s,
3202: msc_part_demands d,
3203: mfg0 mfg,
3204: msc_part_supplies s1,
3205: msc_part_demands d1,

Line 3204: msc_part_supplies s1,

3200: msc_supplies k,
3201: msc_part_supplies s,
3202: msc_part_demands d,
3203: mfg0 mfg,
3204: msc_part_supplies s1,
3205: msc_part_demands d1,
3206: mfg0 mfg1,
3207: msc_part_supplies s2,
3208: msc_part_demands d2,

Line 3207: msc_part_supplies s2,

3203: mfg0 mfg,
3204: msc_part_supplies s1,
3205: msc_part_demands d1,
3206: mfg0 mfg1,
3207: msc_part_supplies s2,
3208: msc_part_demands d2,
3209: msc_system_items msi1
3210: WHERE
3211: k.release_errors IS NULL

Line 3295: UPDATE msc_part_supplies

3291: END LOOP;
3292:
3293: for i IN 1 .. lv_in_req_transaction_id_lst.count LOOP
3294:
3295: UPDATE msc_part_supplies
3296: SET load_type = 32,
3297: --release_status = 2,
3298: --implement_quantity = new_order_quantity, --to be removed if above api works fine
3299: release_errors = NULL,

Line 3366: /* update msc_part_supplies

3362: batch_id = nvl(batch_id,g_batch_id)
3363: where plan_id = p_arg_plan_id
3364: and transaction_id= lv_orig_transaction_id_lst(i);
3365:
3366: /* update msc_part_supplies
3367: set releasable = RELEASE_ATTEMPTED,
3368: batch_id = nvl(batch_id,g_batch_id)
3369: where plan_id = p_arg_plan_id
3370: and transaction_id= lv_transaction_id_lst(i);*/

Line 3615: msc_part_supplies s,

3611: s2.new_order_quantity defective_part_quantity
3612: FROM
3613: msc_supplies k,
3614: msc_system_items msi,
3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,
3619: msc_trading_partners mtp1,

Line 3617: Msc_part_supplies s1,

3613: msc_supplies k,
3614: msc_system_items msi,
3615: msc_part_supplies s,
3616: msc_part_demands d,
3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,
3619: msc_trading_partners mtp1,
3620: msc_part_demands d1,
3621: Msc_part_supplies s2,

Line 3621: Msc_part_supplies s2,

3617: Msc_part_supplies s1,
3618: msc_trading_partners mtp,
3619: msc_trading_partners mtp1,
3620: msc_part_demands d1,
3621: Msc_part_supplies s2,
3622: msc_part_demands d2,
3623: msc_system_items msi1,
3624: (select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
3625: from msc_part_pegging

Line 3702: update msc_part_supplies

3698: ,batch_id = nvl(batch_id,g_batch_id)
3699: where plan_id = p_arg_plan_id
3700: and transaction_id= p_arg_transaction_id;
3701:
3702: update msc_part_supplies
3703: set releasable = RELEASE_ATTEMPTED
3704: ,batch_id = g_batch_id
3705: where plan_id = p_arg_plan_id
3706: and orig_transaction_id= p_arg_transaction_id;

Line 3712: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in

3708: execute immediate 'update msc_supplies
3709: set releasable = ' || RELEASE_ATTEMPTED || '
3710: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
3711: where plan_id = ' || p_arg_plan_id || '
3712: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
3713: (select transaction_id from mrp_ero_release' ||p_dblink||'
3714: where batch_id = ' || p_arg_ero_batch_number || '))';
3715:
3716: execute immediate 'update msc_part_supplies

Line 3716: execute immediate 'update msc_part_supplies

3712: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
3713: (select transaction_id from mrp_ero_release' ||p_dblink||'
3714: where batch_id = ' || p_arg_ero_batch_number || '))';
3715:
3716: execute immediate 'update msc_part_supplies
3717: set releasable = ' || RELEASE_ATTEMPTED || '
3718: ,batch_id =' || g_batch_id || '
3719: where plan_id = ' || p_arg_plan_id || '
3720: and transaction_id in