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_X_NETTING3_PKG dependencies on MSC_SUP_DEM_ENTRIES

Line 57: FROM msc_sup_dem_entries sd

53: sd.supplier_site_id,
54: null,
55: null,
56: sd.key_date)
57: FROM msc_sup_dem_entries sd
58: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
59: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
60: AND msc_x_netting_pkg.does_so_exist(sd.order_number,
61: sd.release_number,

Line 127: FROM msc_sup_dem_entries sd

123: sd.publisher_site_id,
124: null,
125: null,
126: sd.key_date)
127: FROM msc_sup_dem_entries sd
128: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
129: AND sd.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
130: AND msc_x_netting_pkg.does_po_exist(sd.end_order_number,
131: sd.end_order_rel_number,

Line 171: FROM msc_sup_dem_entries sd

167: sd.supplier_site_name,
168: sd.supplier_item_name,
169: sd.supplier_item_description,
170: sd.creation_date
171: FROM msc_sup_dem_entries sd
172: WHERE sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
173: AND sd.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
174: AND sd.last_refresh_number > p_refresh_number;
175:

Line 191: FROM msc_sup_dem_entries sd1,

187: p_supplier_id IN Number,
188: p_supplier_site_id IN Number,
189: p_item_id IN Number) IS
190: SELECT distinct sd2.transaction_id --po trx-id
191: FROM msc_sup_dem_entries sd1,
192: msc_sup_dem_entries sd2
193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
194: AND sd1.plan_id = sd2.plan_id
195: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER --SO

Line 192: msc_sup_dem_entries sd2

188: p_supplier_site_id IN Number,
189: p_item_id IN Number) IS
190: SELECT distinct sd2.transaction_id --po trx-id
191: FROM msc_sup_dem_entries sd1,
192: msc_sup_dem_entries sd2
193: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
194: AND sd1.plan_id = sd2.plan_id
195: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER --SO
196: AND sd1.publisher_id = p_supplier_id

Line 223: FROM msc_sup_dem_entries sd

219: select sd.transaction_id,
220: sd.publisher_order_type,
221: sd.publisher_id,
222: sd.publisher_site_id
223: FROM msc_sup_dem_entries sd
224: START WITH sd.transaction_id = p_transaction_id
225: CONNECT BY sd.end_order_number = PRIOR sd.order_number
226: AND
227: (

Line 290: FROM msc_sup_dem_entries sd1,

286: sd1.supplier_site_id,
287: null,
288: null,
289: sd1.key_date)
290: FROM msc_sup_dem_entries sd1,
291: msc_sup_dem_entries sd2
292: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
293: AND sd1.plan_id = sd2.plan_id
294: AND sd1.inventory_item_id = p_item_id

Line 291: msc_sup_dem_entries sd2

287: null,
288: null,
289: sd1.key_date)
290: FROM msc_sup_dem_entries sd1,
291: msc_sup_dem_entries sd2
292: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
293: AND sd1.plan_id = sd2.plan_id
294: AND sd1.inventory_item_id = p_item_id
295: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

Line 363: FROM msc_sup_dem_entries sd1,

359: sd2.line_number,
360: sd1.order_number,
361: sd1.release_number,
362: sd1.line_number
363: FROM msc_sup_dem_entries sd1,
364: msc_sup_dem_entries sd2
365: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
366: AND sd1.plan_id = sd2.plan_id
367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER

Line 364: msc_sup_dem_entries sd2

360: sd1.order_number,
361: sd1.release_number,
362: sd1.line_number
363: FROM msc_sup_dem_entries sd1,
364: msc_sup_dem_entries sd2
365: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
366: AND sd1.plan_id = sd2.plan_id
367: AND sd1.publisher_order_type = msc_x_netting_pkg.PURCHASE_ORDER
368: AND sd1.publisher_id = sd2.customer_id

Line 419: FROM msc_sup_dem_entries sd1

415: sd1.customer_site_id,
416: sd1.customer_site_name,
417: sd1.customer_item_name,
418: sd1.customer_item_description
419: FROM msc_sup_dem_entries sd1
420: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
421: AND sd1.inventory_item_id = P_ITEM_ID
422: AND sd1.publisher_id = p_customer_id /* sbala P_SUPPLIER_ID */
423: AND sd1.publisher_site_id = p_customer_site_id /* sbala P_SUPPLIER_SITE_ID */

Line 512: FROM msc_sup_dem_entries sd1,

508: sd1.publisher_site_id,
509: sd1.inventory_item_id,
510: sd1.supplier_id,
511: sd1.supplier_site_id
512: FROM msc_sup_dem_entries sd1,
513: msc_trading_partners tp,
514: msc_trading_partner_maps map,
515: msc_item_suppliers itm,
516: msc_trading_partner_maps map2,

Line 577: FROM msc_sup_dem_entries sd1,

573: sd1.supplier_item_name,
574: sd1.supplier_item_description,
575: sd1.creation_date,
576: nvl(itm.processing_lead_time,0)
577: FROM msc_sup_dem_entries sd1,
578: msc_trading_partners tp,
579: msc_trading_partner_maps map,
580: msc_item_suppliers itm,
581: msc_trading_partner_maps map2,

Line 641: FROM msc_sup_dem_entries sd1,

637: sd1.supplier_item_name,
638: sd1.supplier_item_description,
639: sd1.creation_date,
640: nvl(itm.processing_lead_time,0)
641: FROM msc_sup_dem_entries sd1,
642: msc_trading_partners tp,
643: msc_trading_partner_maps map,
644: msc_item_suppliers itm,
645: msc_trading_partner_maps map2,

Line 706: FROM msc_sup_dem_entries sd1

702: sd1.customer_site_name,
703: sd1.customer_item_name,
704: sd1.customer_item_description,
705: sd1.creation_date
706: FROM msc_sup_dem_entries sd1
707: WHERE sd1.plan_id = msc_x_netting_pkg.G_PLAN_ID
708: AND sd1.publisher_order_type = msc_x_netting_pkg.SALES_ORDER
709: AND not exists (SELECT * FROM msc_x_exception_details d
710: WHERE d.exception_type in (3,12)

Line 1817: l_customer_name msc_sup_dem_entries.customer_name%type;

1813: l_so_trx_id Number;
1814: l_po_trx_id Number;
1815: l_customer_id Number;
1816: l_customer_site_id Number;
1817: l_customer_name msc_sup_dem_entries.customer_name%type;
1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;

Line 1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;

1814: l_po_trx_id Number;
1815: l_customer_id Number;
1816: l_customer_site_id Number;
1817: l_customer_name msc_sup_dem_entries.customer_name%type;
1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;

Line 1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;

1815: l_customer_id Number;
1816: l_customer_site_id Number;
1817: l_customer_name msc_sup_dem_entries.customer_name%type;
1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;

Line 1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;

1816: l_customer_site_id Number;
1817: l_customer_name msc_sup_dem_entries.customer_name%type;
1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;
1824: l_supplier_site_id Number;

Line 1821: l_item_name msc_sup_dem_entries.item_name%type;

1817: l_customer_name msc_sup_dem_entries.customer_name%type;
1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;
1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;

Line 1822: l_item_desc msc_sup_dem_entries.item_description%type;

1818: l_customer_site_name msc_sup_dem_entries.customer_site_name%type;
1819: l_customer_item_name msc_sup_dem_entries.customer_item_name%type;
1820: l_customer_item_desc msc_sup_dem_entries.customer_item_description%type;
1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;
1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

Line 1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;

1821: l_item_name msc_sup_dem_entries.item_name%type;
1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;
1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;

Line 1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;

1822: l_item_desc msc_sup_dem_entries.item_description%type;
1823: l_supplier_id Number;
1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;

Line 1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;

1823: l_supplier_id Number;
1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;

Line 1828: l_order_number msc_sup_dem_entries.order_number%type;

1824: l_supplier_site_id Number;
1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;

Line 1829: l_release_number msc_sup_dem_entries.release_number%type;

1825: l_supplier_name msc_sup_dem_entries.supplier_name%type;
1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;

Line 1830: l_line_number msc_sup_dem_entries.line_number%type;

1826: l_supplier_site_name msc_sup_dem_entries.supplier_site_name%type;
1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
1834: l_posting_so_qty Number;

Line 1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;

1827: l_supplier_item_name msc_sup_dem_entries.supplier_item_name%type;
1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
1834: l_posting_so_qty Number;
1835: l_so_qty Number;

Line 1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;

1828: l_order_number msc_sup_dem_entries.order_number%type;
1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
1834: l_posting_so_qty Number;
1835: l_so_qty Number;
1836: l_tp_so_qty Number;

Line 1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;

1829: l_release_number msc_sup_dem_entries.release_number%type;
1830: l_line_number msc_sup_dem_entries.line_number%type;
1831: l_end_order_number msc_sup_dem_entries.end_order_number%type;
1832: l_end_order_rel_number msc_sup_dem_entries.end_order_rel_number%type;
1833: l_end_order_line_number msc_sup_dem_entries.end_order_line_number%type;
1834: l_posting_so_qty Number;
1835: l_so_qty Number;
1836: l_tp_so_qty Number;
1837: l_posting_po_qty Number;

Line 2723: msc_sup_dem_entries sd

2719: msc_companies c2,
2720: msc_company_sites s2,
2721: msc_company_relationships rel,
2722: msc_trading_partner_maps m3,
2723: msc_sup_dem_entries sd
2724: WHERE sup.transaction_id = l_peg_trx_id
2725: AND sup.plan_id = l_plan_order_at_risk_id
2726: AND sup.sr_instance_id = l_peg_sr_instance_id
2727: AND sup.organization_id = l_peg_org_id

Line 3016: msc_sup_dem_entries sd,

3012: msc_companies c2,
3013: msc_company_sites s2,
3014: msc_company_relationships rel,
3015: msc_trading_partner_maps m3,
3016: msc_sup_dem_entries sd,
3017: msc_sales_orders mso
3018: WHERE dem.demand_id = l_demand_id
3019: AND dem.plan_id = l_plan_order_at_risk_id
3020: AND dem.sr_instance_id = l_peg_sr_instance_id