DBA Data[Home] [Help]

APPS.MSC_REL_PLAN_PUB dependencies on MSC_PROJECTS

Line 2828: ' FROM msc_projects mpp, '||

2824: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2825: l_plan_type ||',' ||
2826: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
2827: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2828: ' FROM msc_projects mpp, '||
2829: ' msc_trading_partners mp, ' ||
2830: ' msc_trading_partners mp2,' ||
2831: ' msc_system_items msi, ' ||
2832: ' msc_system_items msi1,' ||

Line 2959: ' FROM msc_projects mpp, '||

2955: ' DECODE(s.implement_firm, 1, ''Y'', ''N''), '||
2956: ' s.transaction_id, ' || -- transaction_id of msc_supplies
2957: l_plan_type ||','||
2958: ' nvl(s.implement_ship_method,s.ship_method) ' ||
2959: ' FROM msc_projects mpp, '||
2960: ' msc_trading_partners mp, ' ||
2961: ' msc_trading_partners mp2,' ||
2962: ' msc_system_items msi, ' ||
2963: ' msc_system_items msi1,' ||

Line 3186: ' FROM msc_projects mpp, ' ||

3182: ' s.transaction_id, ' || -- transaction_id of msc_supplies
3183: l_plan_type ||',' ||
3184: ' decode(s.item_type_value,1,''G'',2,''B'',''G''), ' || -- part condition of msc_supplies -- bug 9031352
3185: ' nvl(s.implement_ship_method,s.ship_method) ' ||
3186: ' FROM msc_projects mpp, ' ||
3187: ' msc_trading_partners mp, ' ||
3188: ' msc_trading_partners mp2, ' ||
3189: 'msc_system_items msi, '||
3190: 'msc_system_items msi1,'||

Line 9647: FROM msc_projects mpp,

9643: s.implement_unit_number,
9644: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9645: s.transaction_id,-- For Outbound Changes for XML
9646: s.sr_instance_id
9647: FROM msc_projects mpp,
9648: --msc_calendar_dates cal1,
9649: --msc_calendar_dates cal2,
9650: msc_tp_id_lid supplier,
9651: msc_trading_partner_sites mtps,

Line 9793: FROM msc_projects mpp,

9789: s.implement_unit_number,
9790: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9791: s.transaction_id, -- Outbound Changes for XML
9792: s.sr_instance_id
9793: FROM msc_projects mpp,
9794: -- msc_calendar_dates cal1,
9795: -- msc_calendar_dates cal2,
9796: msc_tp_id_lid supplier,
9797: msc_trading_partner_sites mtps,

Line 9938: FROM msc_projects mpp,

9934: s.implement_unit_number,
9935: DECODE(s.implement_project_id, NULL, 'N', 'Y'),
9936: s.transaction_id, --outbound changes for XML
9937: s.sr_instance_id
9938: FROM msc_projects mpp,
9939: -- msc_calendar_dates cal1,
9940: -- msc_calendar_dates cal2,
9941: msc_tp_id_lid supplier,
9942: msc_trading_partner_sites mtps,