DBA Data[Home] [Help]

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 135: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

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

Line 172: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

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

Line 286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd

282: , ol.link_to_line_id
283: FROM
284: WSH_NEW_DELIVERIES_OB_GRP_V wnd
285: , wsh_delivery_assignments_v wda
286: , WSH_DELIVERY_DETAILS_OB_GRP_V wdd
287: , OE_ORDER_LINES_ALL ol
288: , hr_organization_information hoi /*Bug 8467743*/
289: WHERE wnd.delivery_id = wda.delivery_id
290: AND wda.delivery_detail_id = wdd.delivery_detail_id

Line 446: , wsh_delivery_details_ob_grp_v wdd

442: , oola.order_quantity_uom
443: FROM
444: OE_ORDER_HEADERS_ALL ooha
445: , OE_ORDER_LINES_ALL oola
446: , wsh_delivery_details_ob_grp_v wdd
447: , wsh_new_deliveries_ob_grp_v wnd
448: , wsh_delivery_assignments_v wda
449: , HZ_PARTIES rac
450: , HZ_CUST_ACCOUNTS hzc

Line 975: FROM wsh_delivery_details_ob_grp_v

971:
972: --Find out the current status
973: SELECT mvt_stat_status
974: INTO l_mvt_stat_status
975: FROM wsh_delivery_details_ob_grp_v
976: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
977:
978: -- Update the transaction table
979: IF l_mvt_stat_status = 'NEW'

Line 1075: FROM wsh_delivery_details_ob_grp_v

1071:
1072: --Find out the current status
1073: SELECT mvt_stat_status
1074: INTO l_mvt_stat_status
1075: FROM wsh_delivery_details_ob_grp_v
1076: WHERE delivery_detail_id = p_delivery_detail_id;
1077:
1078: -- Update the transaction table
1079: IF l_mvt_stat_status = 'NEW'