APPS.OE_LIN dependencies on SO_LINES

Line 494: FROM SO_LINES

490: begin
491:
492: SELECT COUNT(*)
493: INTO L_Count
494: FROM SO_LINES
495: WHERE ROWID = Row_Id
496: AND S2 = 4;
497:
498: if L_Count = 1 then

Line 534: FROM SO_LINES

530:
531:
532: SELECT COUNT(*)
533: INTO L_Count
534: FROM SO_LINES
535: WHERE ROWID = Row_Id
536: AND ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0);
537:
538: if L_Count = 1 then

Line 695: from so_lines

691: l_dummy := null;
692: if p_item_type_code = 'MODEL' then
693: declare cursor service_exists(x_line_id number) is
694: select line_id
695: from so_lines
696: where service_parent_line_id = x_line_id
697: and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0
698: union
699: select lin.line_id

Line 700: from so_lines serv, so_lines lin

696: where service_parent_line_id = x_line_id
697: and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0
698: union
699: select lin.line_id
700: from so_lines serv, so_lines lin
701: where serv.service_parent_line_id = lin.line_id
702: and nvl(serv.ordered_quantity,0) -
703: nvl(serv.cancelled_quantity,0) > 0
704: and lin.parent_line_id = x_line_id;

Line 711: from SO_LINE_SERVICE_DETAILS isd, so_lines lin

707: from SO_LINE_SERVICE_DETAILS
708: where line_id = x_line_id
709: union
710: select lin.line_id
711: from SO_LINE_SERVICE_DETAILS isd, so_lines lin
712: where isd.line_id = lin.line_id
713: and lin.parent_line_id = x_line_id;
714: begin
715: open service_exists(p_line_id);

Line 735: from so_lines

731: end;
732: else -- not a model
733: declare cursor service_exists(x_line_id number) is
734: select line_id
735: from so_lines
736: where service_parent_line_id = x_line_id
737: and nvl(ordered_quantity,0) - nvl(cancelled_quantity,0) > 0;
738:
739: cursor installation_exists(x_line_id number) is

Line 769: FROM SO_LINES

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
770: WHERE HEADER_ID = P_Header_Id
771: AND (LINE_ID = P_Line_Id
772: OR PARENT_LINE_ID = P_Line_Id))
773: AND ROWNUM = 1;

Line 786: FROM SO_LINES

782:
783: if (P_Order_S1 = OE_BOOKED) then
784: begin
785: SELECT NULL into L_Dummy
786: FROM SO_LINES
787: WHERE HEADER_ID = P_Header_Id
788: AND (LINE_ID = P_Line_Id
789: OR PARENT_LINE_ID = P_Line_Id)
790: AND (S2 NOT IN (8,18)

Line 835: FROM SO_LINES L

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
837: AND ATO_LINE_ID IS NOT NULL)
838: OR ( PARENT_LINE_ID = P_ATO_Option_Parent_Line
839: AND ATO_LINE_ID IS NULL