APPS.CHV_CREATE_BUCKETS dependencies on CHV_ITEM_ORDERS

Line 455: ** total ORDER_QUANTITY from CHV_ITEM_ORDERS

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

Line 467: from chv_item_orders cio

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

Line 485: from chv_item_orders cio

481: (num1,
482: num2 )
483: select nvl(sum(round(cio.order_quantity,5)),0) release_quantity,
484: 0 forecast_quantity
485: from chv_item_orders cio
486: where cio.schedule_id = p_schedule_id
487: and cio.schedule_item_id = p_schedule_item_id
488: and cio.supply_document_type = 'RELEASE'
489: and trunc(cio.due_date) <= to_date(p_bucket_end_date_table(x_bucket_count),'YYYY/MM/DD')

Line 514: FROM chv_item_orders cio

510: 'RELEASE_ONLY',0 ,
511: 'FORECAST_ALL_DOCUMENTS', 0,
512: NVL (ROUND (cio.order_quantity, 5), 0))
513: )forecast_qty
514: FROM chv_item_orders cio
515: WHERE cio.schedule_id = p_schedule_id
516: and cio.schedule_item_id = p_schedule_item_id
517: and cio.supply_document_type IN ('RELEASE', 'PLANNED_ORDER', 'REQUISITION')
518: AND p_schedule_type IN ('FORECAST_ALL_DOCUMENTS','FORECAST_ONLY','MATERIAL_RELEASE', 'RELEASE_WITH_FORECAST','RELEASE_ONLY')

Line 526: from chv_item_orders cio

522: union all
523: SELECT
524: nvl(sum(round(cio.order_quantity,5)),0) release_quantity ,
525: 0 forecast_quantity
526: from chv_item_orders cio
527: where cio.schedule_id = p_schedule_id
528: and cio.schedule_item_id = p_schedule_item_id
529: and cio.supply_document_type = 'RELEASE'
530: and trunc(cio.due_date) > to_date(p_bucket_start_date_table(x_bucket_count),'YYYY/MM/DD')