DBA Data[Home] [Help]

APPS.CTO_WIP_UTIL dependencies on WSH_NEW_DELIVERIES_OB_GRP_V

Line 48: | WSH_NEW_DELIVERIES to WSH_NEW_DELIVERIES_OB_GRP_V

44: | Sep 23, 2003 Renga Kannan |
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

Line 850: WSH_NEW_DELIVERIES_OB_GRP_V wnd

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
853: and wdd.source_code = 'OE' --bugfix 1988967
854: and wda.delivery_detail_id = wdd.delivery_detail_id