[Home] [Help]
45: | Changed the following two table acecss to |
46: | view. This change is recommended by shipping |
47: | team to avoid getting inbound/dropship lines.
48: | WSH_NEW_DELIVERIES to WSH_NEW_DELIVERIES_OB_GRP_V
49: WSH_DELIVERY_DETAILS to WSH_DELIVERY_DETAILS_OB_GRP_V
50: This changes brings a wsh dependency to our code
51: the wsh pre-req for this change is 3125046
52: | June 1, 05 Renga Kannann Added nocopy hint
53: =============================================================================*/
119: CURSOR c_delivery_lines IS
120: select sum(wdd.requested_quantity) pQuantity,
121: -- Note: bug 1661094: wdd.requested_quantity is in primary uom
122: wda.delivery_id, wdd.load_seq_number lsn
123: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
124: wsh_delivery_assignments wda
125: where wdd.source_line_id = p_line_id
126: and wda.delivery_detail_id = wdd.delivery_detail_id
127: and wdd.source_code = 'OE' -- bugfix 1988967: only OE lines should be picked since
733: select 1
734: into l_eligible_line
735: from oe_order_lines_all oel
736: where exists (select 'Exists'
737: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
738: wsh_delivery_assignments wda,
739: mtl_customer_items mci
740: where wdd.source_line_id = oel.line_id
741: and mci.customer_item_id = oel.ordered_item_id
784: BEGIN
785: select 'IMPORTED'
786: into l_imported
787: from oe_order_lines_all oel,
788: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
789: mtl_system_items msi --bugfix 2074290: added msi
790: where oel.line_id = p_line_id
791: and wdd.source_line_id = oel.line_id
792: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins
801: msi.primary_uom_code,
802: null,
803: null) = (select nvl(sum(wdd1.requested_quantity), 0) -- bugfix 2017099
804: --end bugfix 2074290
805: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd1
806: where wdd1.source_line_id = oel.line_id
807: and wdd1.source_code = 'OE') --bugfix 1988967
808: and rownum = 1;
809:
825:
826: select 'NOTASSIGNED'
827: into l_assigned
828: from oe_order_lines_all oel,
829: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
830: wsh_delivery_assignments wda
831: where oel.line_id = p_line_id
832: and wdd.source_line_id = oel.line_id
833: and wdd.source_code = 'OE' --bugfix 1988967
862:
863: select 'NOTPLANNED'
864: into l_planned
865: from oe_order_lines_all oel,
866: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
867: wsh_delivery_assignments wda,
868: WSH_NEW_DELIVERIES_OB_GRP_V wnd
869: where oel.line_id = p_line_id
870: and wdd.source_line_id = oel.line_id