DBA Data[Home] [Help]

APPS.WSH_IB_TXN_MATCH_PKG dependencies on WSH_DELIVERY_DETAILS

Line 5822: FROM wsh_delivery_details wdd,

5818: wdd.released_status,
5819: wdd.src_requested_quantity,
5820: wdd.src_requested_quantity2,
5821: wdd.last_update_date
5822: FROM wsh_delivery_details wdd,
5823: wsh_delivery_assignments_v wda,
5824: wsh_new_deliveries wnd
5825: WHERE wdd.source_code = 'PO'
5826: AND NVL(wdd.line_direction,'O') NOT IN ('O','IO')

Line 5951: FROM wsh_delivery_details wdd

5947: )
5948: IS
5949: SELECT requested_quantity_uom, requested_quantity_uom2,
5950: src_requested_quantity,src_requested_quantity2
5951: FROM wsh_delivery_details wdd
5952: WHERE wdd.source_code = 'PO'
5953: AND NVL(wdd.line_direction,'O') NOT IN ('O','IO')
5954: AND wdd.source_header_id = p_source_header_id
5955: AND wdd.source_line_id = p_source_line_id

Line 6009: FROM wsh_delivery_details wdd

6005: p_transactionSubType IN VARCHAR2
6006: )
6007: IS
6008: SELECT COUNT(DISTINCT ship_from_location_id)
6009: FROM wsh_delivery_details wdd
6010: WHERE wdd.source_code = 'PO'
6011: AND NVL(wdd.line_direction,'O') NOT IN ('O','IO')
6012: AND wdd.source_header_id = p_source_header_id
6013: AND wdd.source_line_id = p_source_line_id

Line 6077: FROM wsh_delivery_details wdd

6073: p_source_blanket_Reference_id IN NUMBER
6074: )
6075: IS
6076: SELECT 1
6077: FROM wsh_delivery_details wdd
6078: WHERE wdd.source_code = 'PO'
6079: AND NVL(wdd.line_direction,'O') NOT IN ('O','IO')
6080: AND wdd.source_header_id = p_source_header_id
6081: AND wdd.source_line_id = p_source_line_id