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.

[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_PROJECTS

Line 2293: ' FROM msc_projects mpp, '||

2289: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2290: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2291: l_plan_type ||',' ||
2292: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2293: ' FROM msc_projects mpp, '||
2294: ' msc_trading_partners mp, ' ||
2295: ' msc_trading_partners mp2,' ||
2296: ' msc_system_items msi, ' ||
2297: ' msc_system_items msi1,' ||

Line 2423: ' FROM msc_projects mpp, '||

2419: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2420: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2421: l_plan_type ||','||
2422: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2423: ' FROM msc_projects mpp, '||
2424: ' msc_trading_partners mp, ' ||
2425: ' msc_trading_partners mp2,' ||
2426: ' msc_system_items msi, ' ||
2427: ' msc_system_items msi1,' ||

Line 2646: ' FROM msc_projects mpp, ' ||

2642: ' DECODE(s.implement_firm, 1, ''Y'',''N''), '||
2643: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2644: l_plan_type ||',' ||
2645: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2646: ' FROM msc_projects mpp, ' ||
2647: ' msc_trading_partners mp, ' ||
2648: ' msc_trading_partners mp2, ' ||
2649: 'msc_system_items msi, '||
2650: 'msc_system_items msi1,'||

Line 8787: FROM msc_projects mpp,

8783: s.implement_unit_number,
8784: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
8785: s.transaction_id,-- For Outbound Changes for XML
8786: s.sr_instance_id
8787: FROM msc_projects mpp,
8788: --msc_calendar_dates cal1,
8789: --msc_calendar_dates cal2,
8790: msc_tp_id_lid supplier,
8791: msc_trading_partner_sites mtps,

Line 8930: FROM msc_projects mpp,

8926: s.implement_unit_number,
8927: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
8928: s.transaction_id, -- Outbound Changes for XML
8929: s.sr_instance_id
8930: FROM msc_projects mpp,
8931: -- msc_calendar_dates cal1,
8932: -- msc_calendar_dates cal2,
8933: msc_tp_id_lid supplier,
8934: msc_trading_partner_sites mtps,

Line 9072: FROM msc_projects mpp,

9068: s.implement_unit_number,
9069: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9070: s.transaction_id, --outbound changes for XML
9071: s.sr_instance_id
9072: FROM msc_projects mpp,
9073: -- msc_calendar_dates cal1,
9074: -- msc_calendar_dates cal2,
9075: msc_tp_id_lid supplier,
9076: msc_trading_partner_sites mtps,