DBA Data[Home] [Help]

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY dependencies on WSH_DELIVERY_DETAILS

Line 78: wsh_delivery_details wdd

74: 0 parent_inventory_item_id
75: FROM mtl_system_items_vl msi ,
76: mtl_lot_numbers mln ,
77: wsh_opsm_asn_item_details_v waid ,
78: wsh_delivery_details wdd
79: WHERE wdd.delivery_detail_id = p_delivery_detail_id
80: AND wdd.organization_id = p_organization_id
81: AND waid.delivery_detail_id = wdd.delivery_detail_id + 0
82: AND waid.organization_id = wdd.organization_id + 0

Line 2416: wsh_delivery_details wdd

2412: 0 parent_inventory_item_id
2413: FROM mtl_system_items_vl msi ,
2414: mtl_lot_numbers mln ,
2415: wsh_opsm_asn_item_details_v waid ,
2416: wsh_delivery_details wdd
2417: WHERE wdd.delivery_detail_id = p_delivery_detail_id
2418: AND wdd.organization_id = p_organization_id
2419: AND waid.delivery_detail_id = wdd.delivery_detail_id + 0
2420: AND waid.organization_id = wdd.organization_id + 0