APPS.INV_DIAG_DTXN dependencies on WSH_DELIVERY_DETAILS

Line 43: from wsh_delivery_details wdd

39: group by inventory_item_id, trx_source_line_id, organization_id
40: ) mmt ,
41: ( select wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id,
42: wdd.organization_id, sum(wdd.shipped_quantity) shp_qty
43: from wsh_delivery_details wdd
44: where wdd.source_code = 'OE'
45: and wdd.released_status = 'C'
46: and wdd.serial_number is null
47: group by wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id, wdd.organization_id

Line 276: ' from wsh_delivery_details wdd '||

272: ' and transaction_source_type_id = 8 '||
273: ' group by inventory_item_id, trx_source_line_id, organization_id) mmt , '||
274: '( select wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id, '||
275: ' wdd.organization_id, sum(wdd.shipped_quantity) shp_qty '||
276: ' from wsh_delivery_details wdd '||
277: ' where wdd.source_code = ''OE'' '||
278: ' and wdd.released_status = ''C'' '||
279: ' and wdd.serial_number is null '||
280: ' group by wdd.source_header_number, wdd.source_line_id, wdd.inventory_item_id, wdd.organization_id) wdd1, '||