APPS.OE_VALIDATE_LINE dependencies on WSH_DELIVERY_DETAILS

Line 800: FROM Wsh_Delivery_Details

796: -- Select statement to check whether the set is pick released.
797: /*
798: SELECT count(*)
799: INTO l_ship_set
800: FROM Wsh_Delivery_Details
801: WHERE Ship_Set_Id = p_line_rec.ship_set_id
802: AND Source_Code = 'OE'
803: AND Source_Header_Id = p_line_rec.header_id
804: AND Released_Status In ('S','Y','C')

Line 809: FROM wsh_delivery_details wdd

805: AND ROWNUM = 1; -- 3229707 Removed 'B' from Released_Status check
806: */
807: SELECT count(*)
808: INTO l_ship_set
809: FROM wsh_delivery_details wdd
810: WHERE wdd.ship_set_id = p_line_rec.ship_set_id
811: AND wdd.source_code = 'OE'
812: AND wdd.source_header_id = p_line_rec.header_id
813: AND ((wdd.released_status = 'C')

Line 850: FROM Wsh_Delivery_Details

846: -- Bug 4766576, removed B from Released_Status
847:
848: SELECT count(*)
849: INTO l_smc_model
850: FROM Wsh_Delivery_Details
851: WHERE Ship_Model_Complete_Flag = 'Y'
852: AND Top_Model_Line_Id = p_line_rec.top_model_line_id
853: AND Source_Header_Id = p_line_rec.header_id
854: AND Source_Code = 'OE'

Line 3836: FROM WSH_DELIVERY_DETAILS

3832: CURSOR pick_status IS
3833: SELECT --RELEASED_STATUS, -- 14108180
3834: SRC_REQUESTED_QUANTITY,
3835: SRC_REQUESTED_QUANTITY2
3836: FROM WSH_DELIVERY_DETAILS
3837: WHERE SOURCE_CODE = 'OE'
3838: AND SOURCE_LINE_ID = p_line_rec.line_id
3839: AND released_status in ('Y', 'S', 'N', 'X'); --14108180;
3840: