[Home] [Help]
105: --| modified the query in rpt_get_Received_data |
106: --| to correctly fetched the replenishments |
107: --| received in past xx days. Also, replaced |
108: --| usages of shipping_quantity_uom column of the |
109: --| oe_order_lines_all table by the |
110: --| order_quantity_uom, since this is the correct |
111: --| uom accompanying the shipped_quantity. |
112: --| 21-NOV-2006 vchu bug fix for 5665334: Changed the signature |
113: --| of cfr_before_report_trigger to pass in the |
3292: ,pa_projects_all prj
3293: ,pa_tasks task
3294: ,po_releases_all pra
3295: ,jmf_shikyu_replenishments jsr
3296: ,oe_order_lines_all oola
3297: ,oe_order_headers_all ooha
3298: ,jmf_shikyu_allocations jsa
3299: ,po_line_locations_all plla_s
3300: ,po_headers_all pha_s
3749: from jmf_shikyu_cfr_mid_temp cfr_mid_temp
3750: where cfr_mid_temp.row_type = CFR_TMP_RCV_ROW) cfr_mid_item_group
3751: ,jmf_shikyu_replenishments jsr
3752: ,jmf_shikyu_allocations jsa
3753: ,oe_order_lines_all oola
3754: ,oe_order_headers_all ooha
3755: ,po_line_locations_all plla_s
3756: ,po_headers_all pha_s
3757: ,po_lines_all pla_s
3911: ,oola.order_quantity_uom uom
3912: ,oola.actual_shipment_date shipped_date
3913: ,NVL(plla.need_by_date
3914: ,plla.promised_date) expected_rcv_date
3915: FROM oe_order_lines_all oola
3916: ,oe_order_headers_all ooha
3917: ,po_line_locations_all plla
3918: ,po_lines_all pla
3919: ,po_releases_all pra
4083: ,oola.order_quantity_uom uom
4084: ,oola.actual_shipment_date shipped_date
4085: ,NVL(plla.need_by_date
4086: ,plla.promised_date) expected_rcv_date
4087: FROM oe_order_lines_all oola
4088: ,oe_order_headers_all ooha
4089: ,po_line_locations_all plla
4090: ,po_lines_all pla
4091: ,po_releases_all pra