APPS.OE_SHP_PROCESS dependencies on SO_LINES

Line 182: FROM SO_LINES

178: NVL( SELLING_PRICE, 0 ),
179: P_Order_Currency_Precision), 0 ) ), 0 )
180: INTO P_Shp_Total
181: ,P_Shp_Service_Total
182: FROM SO_LINES
183: WHERE (ROWID = P_Shp_Row_Id
184: OR PARENT_LINE_ID = P_Shp_Line_Id
185: OR SERVICE_PARENT_LINE_ID = P_Shp_Line_Id );
186: elsif ( P_Shp_Serviceable_Flag = 'Y') then

Line 199: FROM SO_LINES

195: NVL( SELLING_PRICE, 0 ),
196: P_Order_Currency_Precision), 0 ) ), 0 )
197: INTO P_Shp_Total
198: ,P_Shp_Service_Total
199: FROM SO_LINES
200: WHERE (ROWID = P_Shp_Row_Id
201: OR SERVICE_PARENT_LINE_ID = P_Shp_Line_Id );
202: else
203: P_Shp_Total:=P_Shp_Line_Total;

Line 462: FROM SO_LINES

458: NVL( CANCELLED_QUANTITY, 0 )) *
459: NVL(SELLING_PRICE, 0 ))
460: , 0)
461: INTO P_Line_Total
462: FROM SO_LINES
463: WHERE ( SHIPMENT_SCHEDULE_LINE_ID = P_line_Id
464: OR SERVICE_PARENT_LINE_ID = P_Line_Id );
465:
466: /*LINE_ID = P_Line_Id

Line 504: FROM SO_LINES

500: NVL( CANCELLED_QUANTITY, 0 ) ), 0 ),
501: COUNT(*)
502: INTO P_Lines_Shipment_Qty_Total,
503: P_Lines_Shipment_Lines_Count
504: FROM SO_LINES
505: WHERE SHIPMENT_SCHEDULE_LINE_ID = P_Lines_Line_Id
506: AND PARENT_LINE_ID IS NULL
507: AND SERVICE_PARENT_LINE_ID IS NULL;
508:

Line 537: UPDATE SO_LINES

533:
534: begin
535:
536: if ( P_Line_Type_Code <> 'REGULAR') then
537: UPDATE SO_LINES
538: SET LINE_TYPE_CODE = 'REGULAR'
539: WHERE LINE_ID = P_Line_Id;
540: elsif ( P_Line_Type_Code <> 'PARENT') then
541: UPDATE SO_LINES

Line 541: UPDATE SO_LINES

537: UPDATE SO_LINES
538: SET LINE_TYPE_CODE = 'REGULAR'
539: WHERE LINE_ID = P_Line_Id;
540: elsif ( P_Line_Type_Code <> 'PARENT') then
541: UPDATE SO_LINES
542: SET LINE_TYPE_CODE = 'PARENT'
543: WHERE LINE_ID = P_Line_Id;
544: end if;
545:

Line 574: FROM SO_LINES

570: begin
571:
572: SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
573: INTO P_Total_Shipment_Quantity
574: FROM SO_LINES
575: WHERE SHIPMENT_SCHEDULE_LINE_ID = P_Ship_Sched_Line_Id
576: AND PARENT_LINE_ID IS NULL
577: AND SERVICE_PARENT_LINE_ID IS NULL;
578:

Line 581: FROM SO_LINES

577: AND SERVICE_PARENT_LINE_ID IS NULL;
578:
579: SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
580: INTO P_Open_Line_Quantity
581: FROM SO_LINES
582: WHERE LINE_ID = P_Ship_Sched_Line_Id;
583: if (Nvl(P_Open_Line_Quantity,0) <> Nvl(P_Total_Shipment_Quantity,0)) ANd
584: nvl(P_Total_Shipment_Quantity,0) <> 0 then
585: P_Return_Status := OE_SHIPMENT_MISMATCH;

Line 620: FROM SO_LINES

616: begin
617:
618: SELECT SUM(NVL(ORDERED_QUANTITY,0) - NVL(CANCELLED_QUANTITY,0))
619: INTO P_Open_Line_Quantity
620: FROM SO_LINES
621: WHERE LINE_ID = P_Ship_Sched_Line_Id;
622:
623: UPDATE SO_LINES
624: SET ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0)

Line 623: UPDATE SO_LINES

619: INTO P_Open_Line_Quantity
620: FROM SO_LINES
621: WHERE LINE_ID = P_Ship_Sched_Line_Id;
622:
623: UPDATE SO_LINES
624: SET ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0)
625: + P_Total_Shipment_Quantity
626: WHERE LINE_ID = P_Ship_Sched_Line_Id;
627:

Line 656: UPDATE SO_LINES

652: x boolean;
653:
654: begin
655:
656: UPDATE SO_LINES
657: SET ORDERED_QUANTITY = NVL(CANCELLED_QUANTITY,0) +
658: (((ORDERED_QUANTITY-NVL(CANCELLED_QUANTITY,0))/
659: (P_Ordered_Quantity-NVL(P_Cancelled_Quantity, 0)))
660: * P_Total_Shipment_Quantity)