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 3191: 'msc_part_supplies s, '||

3187: ' msc_trading_partners mp, ' ||
3188: ' msc_trading_partners mp2, ' ||
3189: 'msc_system_items msi, '||
3190: 'msc_system_items msi1,'||
3191: 'msc_part_supplies s, '||
3192: 'msc_plan_organizations_v orgs '||
3193: 'WHERE mpp.organization_id (+)= s.organization_id '||
3194: 'AND mpp.project_id (+)= nvl(s.implement_project_id,-23453) ' ||
3195: 'AND mpp.plan_id (+)= s.plan_id '||

Line 3263: from msc_part_supplies ms, msc_single_lvl_peg mslp

3259: END IF;
3260:
3261: /* update mrp_org_transfer_release motr
3262: set earliest_ship_date = (select max(ms.new_schedule_date)
3263: from msc_part_supplies ms, msc_single_lvl_peg mslp
3264: where ms.plan_id=l_arg_plan_id
3265: and ms.transaction_id = mslp.child_id
3266: and ms.plan_id= mslp.plan_id
3267: and mslp.parent_id = motr.transaction_id

Line 3281: /* update msc_part_supplies

3277: batch_id = nvl(batch_id,g_batch_id)
3278: where plan_id = l_arg_plan_id
3279: and transaction_id= l_arg_transaction_id;
3280:
3281: /* update msc_part_supplies
3282: set releasable = RELEASE_ATTEMPTED,
3283: batch_id = nvl(batch_id,g_batch_id)
3284: where plan_id = l_arg_plan_id
3285: and transaction_id= l_arg_transaction_id; */

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

3287: execute immediate ' update msc_supplies
3288: set releasable = ' || RELEASE_ATTEMPTED || ',
3289: batch_id = nvl(batch_id,' ||g_batch_id ||')
3290: where plan_id = ' || l_arg_plan_id || '
3291: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
3292: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
3293: where batch_id = ' || l_arg_po_batch_number || '))';
3294:
3295: execute immediate ' update msc_part_supplies

Line 3295: execute immediate ' update msc_part_supplies

3291: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
3292: (select transaction_id from MRP_ORG_TRANSFER_RELEASE' || l_dblink || '
3293: where batch_id = ' || l_arg_po_batch_number || '))';
3294:
3295: execute immediate ' update msc_part_supplies
3296: set releasable = ' || RELEASE_ATTEMPTED || ',
3297: batch_id = nvl(batch_id,' ||g_batch_id ||')
3298: where plan_id = ' || l_arg_plan_id || '
3299: and transaction_id in

Line 3741: msc_part_supplies s,

3737: s.implement_source_org_id,
3738: k.transaction_id
3739: FROM
3740: msc_supplies k,
3741: msc_part_supplies s,
3742: msc_part_demands d,
3743: mfg0 mfg,
3744: msc_part_supplies s1,
3745: msc_part_demands d1,

Line 3744: msc_part_supplies s1,

3740: msc_supplies k,
3741: msc_part_supplies s,
3742: msc_part_demands d,
3743: mfg0 mfg,
3744: msc_part_supplies s1,
3745: msc_part_demands d1,
3746: mfg0 mfg1,
3747: msc_part_supplies s2,
3748: msc_part_demands d2,

Line 3747: msc_part_supplies s2,

3743: mfg0 mfg,
3744: msc_part_supplies s1,
3745: msc_part_demands d1,
3746: mfg0 mfg1,
3747: msc_part_supplies s2,
3748: msc_part_demands d2,
3749: msc_system_items msi1
3750: WHERE
3751: k.release_errors IS NULL

Line 3835: UPDATE msc_part_supplies

3831: END LOOP;
3832:
3833: for i IN 1 .. lv_in_req_transaction_id_lst.count LOOP
3834:
3835: UPDATE msc_part_supplies
3836: SET load_type = 32,
3837: --release_status = 2,
3838: --implement_quantity = new_order_quantity, --to be removed if above api works fine
3839: release_errors = NULL,

Line 3906: /* update msc_part_supplies

3902: batch_id = nvl(batch_id,g_batch_id)
3903: where plan_id = p_arg_plan_id
3904: and transaction_id= lv_orig_transaction_id_lst(i);
3905:
3906: /* update msc_part_supplies
3907: set releasable = RELEASE_ATTEMPTED,
3908: batch_id = nvl(batch_id,g_batch_id)
3909: where plan_id = p_arg_plan_id
3910: and transaction_id= lv_transaction_id_lst(i);*/

Line 4156: msc_part_supplies s,

4152: s2.new_order_quantity defective_part_quantity
4153: FROM
4154: msc_supplies k,
4155: msc_system_items msi,
4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,
4160: msc_trading_partners mtp1,

Line 4158: Msc_part_supplies s1,

4154: msc_supplies k,
4155: msc_system_items msi,
4156: msc_part_supplies s,
4157: msc_part_demands d,
4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,
4160: msc_trading_partners mtp1,
4161: msc_part_demands d1,
4162: Msc_part_supplies s2,

Line 4162: Msc_part_supplies s2,

4158: Msc_part_supplies s1,
4159: msc_trading_partners mtp,
4160: msc_trading_partners mtp1,
4161: msc_part_demands d1,
4162: Msc_part_supplies s2,
4163: msc_part_demands d2,
4164: msc_system_items msi1,
4165: (select distinct transaction_id,plan_id,organization_id ,sr_instance_id ,demand_id
4166: from msc_part_pegging

Line 4244: update msc_part_supplies

4240: ,batch_id = nvl(batch_id,g_batch_id)
4241: where plan_id = p_arg_plan_id
4242: and transaction_id= p_arg_transaction_id;
4243:
4244: update msc_part_supplies
4245: set releasable = RELEASE_ATTEMPTED
4246: ,batch_id = g_batch_id
4247: where plan_id = p_arg_plan_id
4248: and orig_transaction_id= p_arg_transaction_id;

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

4250: execute immediate 'update msc_supplies
4251: set releasable = ' || RELEASE_ATTEMPTED || '
4252: ,batch_id = nvl(batch_id,' ||g_batch_id || ')
4253: where plan_id = ' || p_arg_plan_id || '
4254: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
4255: (select transaction_id from mrp_ero_release' ||p_dblink||'
4256: where batch_id = ' || p_arg_ero_batch_number || '))';
4257:
4258: execute immediate 'update msc_part_supplies

Line 4258: execute immediate 'update msc_part_supplies

4254: and transaction_id in (select orig_transaction_id from msc_part_supplies where transaction_id in
4255: (select transaction_id from mrp_ero_release' ||p_dblink||'
4256: where batch_id = ' || p_arg_ero_batch_number || '))';
4257:
4258: execute immediate 'update msc_part_supplies
4259: set releasable = ' || RELEASE_ATTEMPTED || '
4260: ,batch_id =' || g_batch_id || '
4261: where plan_id = ' || p_arg_plan_id || '
4262: and transaction_id in