DBA Data[Home] [Help]

APPS.INV_MGD_MVT_SO_MDTR dependencies on HZ_CUST_ACCOUNTS

Line 436: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS

432: , oola.orig_sys_line_ref
433: , ooha.orig_sys_document_ref
434: , ooha.order_source_id
435: , rac.party_name
436: --Bugfix 9676611: customer_number should come from HZ_CUST_ACCOUNTS
437: --, rac.party_number
438: , hzc.account_number
439: , substrb(rac.province,1,30)
440: , wnd.name

Line 450: , HZ_CUST_ACCOUNTS hzc

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
451: , MTL_SYSTEM_ITEMS si
452: WHERE wnd.delivery_id = wda.delivery_id
453: AND wda.delivery_detail_id = wdd.delivery_detail_id
454: AND ooha.header_id = oola.header_id