APPS.WSH_WSHRDINV_XMLP_PKG dependencies on WSH_DELIVERY_DETAILS

Line 222: WSH_DELIVERY_DETAILS WDD

218: SELECT
219: count(*)
220: FROM
221: WSH_DELIVERY_ASSIGNMENTS_V WDA,
222: WSH_DELIVERY_DETAILS WDD
223: WHERE WDD.DELIVERY_DETAIL_ID = WDA.DELIVERY_DETAIL_ID
224: AND WDD.CONTAINER_FLAG = 'Y'
225: AND WDA.PARENT_DELIVERY_DETAIL_ID IS NULL
226: AND WDA.DELIVERY_ID is not null

Line 753: from wsh_delivery_details wdd

749: where deliverable_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
750: --RTV changes
751: cursor efc_selling_price is
752: select unit_price
753: from wsh_delivery_details wdd
754: where wdd.source_line_id = p_source_line_id
755: and wdd.source_code = p_source_code
756: and rownum < 2;
757:

Line 810: from wsh_delivery_details wdd

806: where deliverable_id = p_source_line_id; --Bug 9166141 changed line_id to source_line_id
807: --RTV changes
808: cursor efc_selling_price is
809: select unit_price
810: from wsh_delivery_details wdd
811: where wdd.source_line_id = p_source_line_id
812: and wdd.source_code = p_source_code
813: and rownum < 2;
814: