DBA Data[Home] [Help]

APPS.WMS_SHIPPING_LOVS dependencies on WSH_DELIVERY_DETAILS

Line 30: FROM wsh_delivery_details wdd

26: , wdd.source_header_type_id
27: , party.party_name --c.customer_name
28: , party.party_id --c.customer_id
29: , party.party_number--c.customer_number
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

Line 57: FROM wsh_delivery_details wdd

53: , wdd.source_header_type_id
54: , party.party_name --c.customer_name
55: , party.party_id --c.customer_id
56: , party.party_number--c.customer_number
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

Line 119: , wsh_delivery_details wdd

115: , ''
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')