DBA Data[Home] [Help]

APPS.INV_PICK_SLIP_REPORT dependencies on WSH_DELIVERY_DETAILS

Line 133: FROM wsh_delivery_details wdd

129: AND (p_dest_subinv IS NULL OR mtrl.to_subinventory_code = p_dest_subinv)
130: AND (p_dest_locator_id IS NULL OR mtrl.to_locator_id = p_dest_locator_id)
131: AND ((p_sales_order_from IS NULL AND p_sales_order_to IS NULL AND p_customer_id IS NULL AND p_freight_code IS NULL)
132: OR EXISTS (SELECT 1
133: FROM wsh_delivery_details wdd
134: WHERE wdd.organization_id = p_org_id
135: AND wdd.move_order_line_id = mtrl.line_id
136: AND (p_sales_order_from IS NULL OR wdd.source_header_number >= p_sales_order_from)
137: AND (p_sales_order_to IS NULL OR wdd.source_header_number <= p_sales_order_to)

Line 169: FROM wsh_delivery_details wdd

165: AND (p_date_reqd_to IS NULL OR (mtrl.date_required <= trunc(p_date_reqd_to+1)-0.00001)) /* Added to fix Bug# 4078103 */
166: --bug 6850379
167: AND ((p_sales_order_from IS NULL AND p_sales_order_to IS NULL AND p_customer_id IS NULL AND p_freight_code IS NULL)
168: OR EXISTS (SELECT 1
169: FROM wsh_delivery_details wdd
170: WHERE wdd.organization_id = p_org_id
171: AND wdd.move_order_line_id = mtrl.line_id
172: AND (p_sales_order_from IS NULL OR wdd.source_header_number >= p_sales_order_from)
173: AND (p_sales_order_to IS NULL OR wdd.source_header_number <= p_sales_order_to)