DBA Data[Home] [Help]

APPS.WMS_SHIPPING_LOVS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 34: , wsh_delivery_assignments_v wda

30: FROM wsh_delivery_details wdd
31: , hz_parties party --ra_customers c
32: , hz_cust_accounts cust_acct
33: , oe_transaction_types_tl otl
34: , wsh_delivery_assignments_v wda
35: WHERE wdd.customer_id = party.party_id
36: --c.customer_id
37: AND cust_acct.party_id = party.party_id
38: AND otl.language=userenv('LANG')

Line 61: , wsh_delivery_assignments_v wda

57: FROM wsh_delivery_details wdd
58: , hz_parties party --ra_customers c
59: , hz_cust_accounts cust_acct
60: , oe_transaction_types_tl otl
61: , wsh_delivery_assignments_v wda
62: WHERE wdd.customer_id = party.party_id
63: --c.customer_id
64: AND cust_acct.party_id = party.party_id
65: AND otl.language=userenv('LANG')

Line 120: , wsh_delivery_assignments_v wda

116: , 0
117: FROM oe_order_lines_all oel
118: , mtl_system_items_kfv msik
119: , wsh_delivery_details wdd
120: , wsh_delivery_assignments_v wda
121: WHERE oel.ship_from_org_id = p_organization_id
122: AND oel.header_id = p_source_header_id
123: AND oel.item_type_code in ('STANDARD','CONFIG','INCLUDED','OPTION')
124: AND wda.parent_delivery_detail_id = p_parent_delivery_detail_id