APPS.OE_LIN dependencies on SO_LINE_DETAILS

Line 631: FROM SO_LINE_DETAILS

627: return;
628: end if;
629:
630: SELECT NULL INTO L_Dummy
631: FROM SO_LINE_DETAILS
632: WHERE LINE_ID = P_Lin_Obj_Line_Id
633: AND SCHEDULE_STATUS_CODE = 'SUPPLY RESERVED';
634:
635: P_Lin_Obj_Supply_Reserv_Exists:='Y';

Line 646: FROM SO_LINE_DETAILS

642:
643: begin
644:
645: SELECT NULL INTO L_Dummy
646: FROM SO_LINE_DETAILS
647: WHERE NVL ( CONFIGURATION_ITEM_FLAG , 'N' ) = 'Y'
648: AND LINE_ID = P_Lin_Obj_Line_Id;
649:
650: P_Lin_Obj_Config_Item_Exists:='Y';

Line 765: FROM SO_LINE_DETAILS

761: end if; -- item_type = MODEL
762: end if; -- service installed
763:
764: SELECT NULL into L_Dummy
765: FROM SO_LINE_DETAILS
766: WHERE SCHEDULE_STATUS_CODE IS NOT NULL
767: AND LINE_ID IN
768: (SELECT LINE_ID
769: FROM SO_LINES

Line 832: UPDATE SO_LINE_DETAILS

828: begin
829:
830: P_Return_Status:=OE_SUCCESS;
831:
832: UPDATE SO_LINE_DETAILS
833: SET SHIPPABLE_FLAG = 'N'
834: WHERE LINE_ID IN ( SELECT L.LINE_ID
835: FROM SO_LINES L
836: WHERE ( PARENT_LINE_ID = P_ATO_Option_Parent_Line