APPS.OE_VALIDATE_LINE dependencies on WSH_DELIVERY_DETAILS

Line 776: FROM Wsh_Delivery_Details

772: -- Select statement to check whether the set is pick released.
773: /*
774: SELECT count(*)
775: INTO l_ship_set
776: FROM Wsh_Delivery_Details
777: WHERE Ship_Set_Id = p_line_rec.ship_set_id
778: AND Source_Code = 'OE'
779: AND Source_Header_Id = p_line_rec.header_id
780: AND Released_Status In ('S','Y','C')

Line 785: FROM wsh_delivery_details wdd

781: AND ROWNUM = 1; -- 3229707 Removed 'B' from Released_Status check
782: */
783: SELECT count(*)
784: INTO l_ship_set
785: FROM wsh_delivery_details wdd
786: WHERE wdd.ship_set_id = p_line_rec.ship_set_id
787: AND wdd.source_code = 'OE'
788: AND wdd.source_header_id = p_line_rec.header_id
789: AND ((wdd.released_status = 'C')

Line 826: FROM Wsh_Delivery_Details

822: -- Bug 4766576, removed B from Released_Status
823:
824: SELECT count(*)
825: INTO l_smc_model
826: FROM Wsh_Delivery_Details
827: WHERE Ship_Model_Complete_Flag = 'Y'
828: AND Top_Model_Line_Id = p_line_rec.top_model_line_id
829: AND Source_Header_Id = p_line_rec.header_id
830: AND Source_Code = 'OE'

Line 3709: FROM WSH_DELIVERY_DETAILS

3705: l_mast_org_id NUMBER := OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
3706: CURSOR pick_status IS
3707: SELECT RELEASED_STATUS, SRC_REQUESTED_QUANTITY,
3708: SRC_REQUESTED_QUANTITY2
3709: FROM WSH_DELIVERY_DETAILS
3710: WHERE SOURCE_CODE = 'OE'
3711: AND SOURCE_LINE_ID = p_line_rec.line_id;
3712:
3713: --End Bug 2639667