DBA Data[Home] [Help]

APPS.MSC_DEMAND_PKG dependencies on MSC_APCC_ITEM_D

Line 1420: msc_apcc_item_d msi

1416: sum(f.sales_order_pd * nvl(msi.list_price,0)*(1-nvl(msi.average_discount,0)/100)) sales_order_pd_value
1417: from
1418: msc_st_demands_f f,
1419: msc_trading_partners mtp,
1420: msc_apcc_item_d msi
1421: where f.st_transaction_id=l_transfer_id
1422: and mtp.partner_type(+)=3
1423: and f.owning_inst_id=mtp.sr_instance_id(+)
1424: and f.owning_org_id=mtp.sr_tp_id(+)