APPS.CHV_CREATE_BUCKETS dependencies on CHV_ITEM_ORDERS

Line 458: ** total ORDER_QUANTITY from CHV_ITEM_ORDERS

454:
455: if p_bucket_descriptor_table(x_bucket_count) = 'PAST_DUE' then
456:
457: /* Calculate Past Due Bucket Quantity by selecting
458: ** total ORDER_QUANTITY from CHV_ITEM_ORDERS
459: ** based on the due_date.
460: */
461:
462: begin

Line 470: from chv_item_orders cio

466: select nvl(sum(round(cio.order_quantity,5)),0),
467: nvl(sum(round(cio.order_quantity_primary,5)),0)
468: into x_release_quantity,
469: x_release_quantity_primary
470: from chv_item_orders cio
471: where cio.schedule_id = p_schedule_id
472: and cio.schedule_item_id = p_schedule_item_id
473: and cio.supply_document_type = 'RELEASE'
474: and trunc(cio.due_date) <= to_date(p_bucket_end_date_table(x_bucket_count),'YYYY/MM/DD') ;

Line 490: ** total ORDER_QUANTITY from CHV_ITEM_ORDERS

486: elsif p_bucket_descriptor_table(x_bucket_count) in ('DAY','BUFFER','WEEK','MONTH',
487: 'QUARTER') then
488:
489: /* Calculate Bucket Firm and Forecast Quantity by selecting
490: ** total ORDER_QUANTITY from CHV_ITEM_ORDERS
491: ** based on the due_date.
492: */
493:
494: begin

Line 498: /* Selecting forecast quantities from chv_item_orders

494: begin
495:
496: x_progress := '030' ;
497:
498: /* Selecting forecast quantities from chv_item_orders
499: ** for the scheduled_item.
500: */
501:
502: select nvl(sum(round(cio.order_quantity,5)),0)

Line 504: from chv_item_orders cio

500: */
501:
502: select nvl(sum(round(cio.order_quantity,5)),0)
503: into x_forecast_quantity
504: from chv_item_orders cio
505: where cio.schedule_id = p_schedule_id
506: and cio.schedule_item_id = p_schedule_item_id
507: and ((p_schedule_type = 'FORECAST_ALL_DOCUMENTS'
508: and cio.supply_document_type in ('RELEASE','PLANNED_ORDER','REQUISITION')

Line 528: /* Selecting release quantities from chv_item_orders

524: begin
525:
526: x_progress := '040' ;
527:
528: /* Selecting release quantities from chv_item_orders
529: ** for the scheduled_item.
530: */
531:
532: select nvl(sum(round(cio.order_quantity,5)),0)

Line 534: from chv_item_orders cio

530: */
531:
532: select nvl(sum(round(cio.order_quantity,5)),0)
533: into x_release_quantity
534: from chv_item_orders cio
535: where cio.schedule_id = p_schedule_id
536: and cio.schedule_item_id = p_schedule_item_id
537: and p_schedule_type in ('RELEASE_ONLY','MATERIAL_RELEASE','RELEASE_WITH_FORECAST')
538: and cio.supply_document_type = 'RELEASE'

Line 551: /* Select all future releases from CHV_ITEM_ORDERS for the future

547: x_total_quantity_table(x_bucket_count) := x_release_quantity + x_forecast_quantity ;
548:
549: elsif p_bucket_descriptor_table(x_bucket_count) = 'FUTURE' then
550:
551: /* Select all future releases from CHV_ITEM_ORDERS for the future
552: ** release bucket.
553: */
554:
555: begin

Line 561: from chv_item_orders cio

557: x_progress := '050' ;
558:
559: select nvl(sum(round(cio.order_quantity,5)),0)
560: into x_release_quantity
561: from chv_item_orders cio
562: where cio.schedule_id = p_schedule_id
563: and cio.schedule_item_id = p_schedule_item_id
564: and cio.supply_document_type = 'RELEASE'
565: and trunc(cio.due_date) > to_date(p_bucket_start_date_table(x_bucket_count),'YYYY/MM/DD') ;