APPS.CTO_WIP_UTIL dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 49: WSH_DELIVERY_DETAILS to WSH_DELIVERY_DETAILS_OB_GRP_V

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: =============================================================================*/

Line 123: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,

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

Line 719: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,

715: select 1
716: into l_eligible_line
717: from oe_order_lines_all oel
718: where exists (select 'Exists'
719: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
720: wsh_delivery_assignments wda,
721: mtl_customer_items mci
722: where wdd.source_line_id = oel.line_id
723: and mci.customer_item_id = oel.ordered_item_id

Line 770: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,

766: BEGIN
767: select 'IMPORTED'
768: into l_imported
769: from oe_order_lines_all oel,
770: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
771: mtl_system_items msi --bugfix 2074290: added msi
772: where oel.line_id = p_line_id
773: and wdd.source_line_id = oel.line_id
774: and oel.inventory_item_id = msi.inventory_item_id --bugfix 2074290: added joins

Line 787: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd1

783: msi.primary_uom_code,
784: null,
785: null) = (select nvl(sum(wdd1.requested_quantity), 0) -- bugfix 2017099
786: --end bugfix 2074290
787: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd1
788: where wdd1.source_line_id = oel.line_id
789: and wdd1.source_code = 'OE') --bugfix 1988967
790: and rownum = 1;
791:

Line 811: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,

807:
808: select 'NOTASSIGNED'
809: into l_assigned
810: from oe_order_lines_all oel,
811: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
812: wsh_delivery_assignments wda
813: where oel.line_id = p_line_id
814: and wdd.source_line_id = oel.line_id
815: and wdd.source_code = 'OE' --bugfix 1988967

Line 848: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,

844:
845: select 'NOTPLANNED'
846: into l_planned
847: from oe_order_lines_all oel,
848: WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
849: wsh_delivery_assignments wda,
850: WSH_NEW_DELIVERIES_OB_GRP_V wnd
851: where oel.line_id = p_line_id
852: and wdd.source_line_id = oel.line_id