DBA Data[Home] [Help]

APPS.MSC_X_NETTING2_PKG dependencies on MSC_CP_PLAN_BUCKETS

Line 48: msc_cp_plan_buckets bkt

44: nvl(sum(sd.tp_quantity),0),
45: nvl(sum(sd.quantity),0),
46: nvl(max(sd.last_refresh_number),0)
47: from msc_sup_dem_entries sd,
48: msc_cp_plan_buckets bkt
49: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
50: and sd.publisher_id = bkt.supplier_id
51: and sd.publisher_site_id = bkt.supplier_site_id
52: and sd.customer_id = bkt.customer_id

Line 101: msc_cp_plan_buckets bkt

97: nvl(sum(sd.tp_quantity),0),
98: nvl(sum(sd.quantity),0),
99: nvl(max(sd.last_refresh_number),0)
100: from msc_sup_dem_entries sd,
101: msc_cp_plan_buckets bkt
102: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
103: and sd.publisher_id = bkt.customer_id
104: and sd.publisher_site_id = bkt.customer_site_id
105: and nvl(sd.base_item_id,sd.inventory_item_id) = bkt.inventory_item_id

Line 162: msc_cp_plan_buckets bkt

158: nvl(sum(sd.tp_quantity),0),
159: nvl(sum(sd.quantity),0),
160: nvl(max(sd.last_refresh_number),0)
161: from msc_sup_dem_entries sd,
162: msc_cp_plan_buckets bkt
163: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
164: and sd.publisher_id = bkt.customer_id
165: and sd.publisher_site_id = bkt.customer_site_id
166: and nvl(sd.base_item_id,sd.inventory_item_id) = bkt.inventory_item_id

Line 215: msc_cp_plan_buckets bkt

211: nvl(sum(sd.tp_quantity),0),
212: nvl(sum(sd.quantity),0),
213: nvl(max(sd.last_refresh_number),0)
214: from msc_sup_dem_entries sd,
215: msc_cp_plan_buckets bkt
216: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
217: and sd.publisher_id = bkt.supplier_id
218: and sd.publisher_site_id = bkt.supplier_site_id
219: and sd.customer_id = bkt.customer_id

Line 471: msc_cp_plan_buckets bkt

467: nvl(sum(sd.tp_quantity),0),
468: nvl(sum(sd.quantity),0),
469: nvl(max(sd.last_refresh_number),0)
470: from msc_sup_dem_entries sd,
471: msc_cp_plan_buckets bkt
472: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
473: and sd.publisher_id = bkt.supplier_id
474: and sd.publisher_site_id = bkt.supplier_site_id
475: and sd.customer_id = bkt.customer_id

Line 524: msc_cp_plan_buckets bkt

520: nvl(sum(sd.tp_quantity),0),
521: nvl(sum(sd.quantity),0),
522: nvl(max(sd.last_refresh_number),0)
523: from msc_sup_dem_entries sd,
524: msc_cp_plan_buckets bkt
525: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
526: and sd.publisher_id = bkt.customer_id
527: and sd.publisher_site_id = bkt.customer_site_id
528: and nvl(sd.base_item_id,sd.inventory_item_id) = bkt.inventory_item_id

Line 586: msc_cp_plan_buckets bkt

582: nvl(sum(sd.tp_quantity),0),
583: nvl(sum(sd.quantity),0),
584: nvl(max(sd.last_refresh_number),0)
585: from msc_sup_dem_entries sd,
586: msc_cp_plan_buckets bkt
587: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
588: and sd.publisher_id = bkt.customer_id
589: and sd.publisher_site_id = bkt.customer_site_id
590: and nvl(sd.base_item_id,sd.inventory_item_id) = bkt.inventory_item_id

Line 639: msc_cp_plan_buckets bkt

635: nvl(sum(sd.tp_quantity),0),
636: nvl(sum(sd.quantity),0),
637: nvl(max(sd.last_refresh_number),0)
638: from msc_sup_dem_entries sd,
639: msc_cp_plan_buckets bkt
640: where sd.plan_id = msc_x_netting_pkg.G_PLAN_ID
641: and sd.publisher_id = bkt.supplier_id
642: and sd.publisher_site_id = bkt.supplier_site_id
643: and sd.customer_id = bkt.customer_id