APPS.INV_MGD_MVT_SO_MDTR dependencies on WSH_DELIVERY_DETAILS_OB_GRP_V

Line 98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

94: , ol.link_to_line_id
95: FROM
96: WSH_NEW_DELIVERIES_OB_GRP_V wnd
97: , wsh_delivery_assignments_v wda
98: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
99: , hr_organization_information hoi
100: , OE_ORDER_LINES_ALL ol
101: , OE_ORDER_HEADERS_ALL oh
102: , HZ_CUST_SITE_USES_ALL ras

Line 134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

130: , ol.link_to_line_id
131: FROM
132: WSH_NEW_DELIVERIES_OB_GRP_V wnd
133: , wsh_delivery_assignments_v wda
134: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
135: , hr_organization_information hoi
136: , OE_ORDER_LINES_ALL ol
137: , OE_ORDER_HEADERS_ALL oh
138: , HZ_CUST_SITE_USES_ALL ras

Line 170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

166: , ol.link_to_line_id
167: FROM
168: WSH_NEW_DELIVERIES_OB_GRP_V wnd
169: , wsh_delivery_assignments_v wda
170: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
171: , OE_ORDER_LINES_ALL ol
172: , OE_ORDER_HEADERS_ALL oh
173: , HZ_CUST_SITE_USES_ALL ras
174: , hr_organization_information hoi

Line 283: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

279: , ol.link_to_line_id
280: FROM
281: WSH_NEW_DELIVERIES_OB_GRP_V wnd
282: , wsh_delivery_assignments_v wda
283: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
284: , OE_ORDER_LINES_ALL ol
285: WHERE wnd.delivery_id = wda.delivery_id
286: AND wda.delivery_detail_id = wdd.delivery_detail_id
287: AND wdd.source_line_id = ol.line_id

Line 436: , wsh_delivery_details_ob_grp_v wdd

432: , oola.order_quantity_uom
433: FROM
434: OE_ORDER_HEADERS_ALL ooha
435: , OE_ORDER_LINES_ALL oola
436: , wsh_delivery_details_ob_grp_v wdd
437: , wsh_new_deliveries_ob_grp_v wnd
438: , wsh_delivery_assignments_v wda
439: , HZ_PARTIES rac
440: , HZ_CUST_ACCOUNTS hzc

Line 936: FROM wsh_delivery_details_ob_grp_v

932:
933: --Find out the current status
934: SELECT mvt_stat_status
935: INTO l_mvt_stat_status
936: FROM wsh_delivery_details_ob_grp_v
937: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
938:
939: -- Update the transaction table
940: IF l_mvt_stat_status = 'NEW'

Line 1036: FROM wsh_delivery_details_ob_grp_v

1032:
1033: --Find out the current status
1034: SELECT mvt_stat_status
1035: INTO l_mvt_stat_status
1036: FROM wsh_delivery_details_ob_grp_v
1037: WHERE delivery_detail_id = p_delivery_detail_id;
1038:
1039: -- Update the transaction table
1040: IF l_mvt_stat_status = 'NEW'